{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "d211ecfe",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "f5b44657",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>报表日期</th>\n",
       "      <th>单位</th>\n",
       "      <th>一、营业总收入</th>\n",
       "      <th>营业收入</th>\n",
       "      <th>二、营业总成本</th>\n",
       "      <th>营业成本</th>\n",
       "      <th>营业税金及附加</th>\n",
       "      <th>销售费用</th>\n",
       "      <th>管理费用</th>\n",
       "      <th>财务费用</th>\n",
       "      <th>...</th>\n",
       "      <th>五、净利润</th>\n",
       "      <th>归属于母公司所有者的净利润</th>\n",
       "      <th>少数股东损益</th>\n",
       "      <th>六、每股收益</th>\n",
       "      <th>基本每股收益(元/股)</th>\n",
       "      <th>稀释每股收益(元/股)</th>\n",
       "      <th>七、其他综合收益</th>\n",
       "      <th>八、综合收益总额</th>\n",
       "      <th>归属于母公司所有者的综合收益总额</th>\n",
       "      <th>归属于少数股东的综合收益总额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20221231</td>\n",
       "      <td>元</td>\n",
       "      <td>3.826401e+10</td>\n",
       "      <td>3.826401e+10</td>\n",
       "      <td>2.904984e+10</td>\n",
       "      <td>2.539550e+10</td>\n",
       "      <td>1.770219e+08</td>\n",
       "      <td>2.235237e+09</td>\n",
       "      <td>3.741262e+08</td>\n",
       "      <td>13798317.84</td>\n",
       "      <td>...</td>\n",
       "      <td>7.539000e+09</td>\n",
       "      <td>7.539000e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.7119</td>\n",
       "      <td>4.7119</td>\n",
       "      <td>0</td>\n",
       "      <td>7.539000e+09</td>\n",
       "      <td>7.539000e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20220930</td>\n",
       "      <td>元</td>\n",
       "      <td>2.782329e+10</td>\n",
       "      <td>2.782329e+10</td>\n",
       "      <td>2.107379e+10</td>\n",
       "      <td>1.858638e+10</td>\n",
       "      <td>1.273912e+08</td>\n",
       "      <td>1.469335e+09</td>\n",
       "      <td>2.758392e+08</td>\n",
       "      <td>7344287.22</td>\n",
       "      <td>...</td>\n",
       "      <td>5.607155e+09</td>\n",
       "      <td>5.607155e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.5045</td>\n",
       "      <td>3.5045</td>\n",
       "      <td>0</td>\n",
       "      <td>5.607155e+09</td>\n",
       "      <td>5.607155e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20220630</td>\n",
       "      <td>元</td>\n",
       "      <td>1.835375e+10</td>\n",
       "      <td>1.835375e+10</td>\n",
       "      <td>1.381560e+10</td>\n",
       "      <td>1.221367e+10</td>\n",
       "      <td>8.491797e+07</td>\n",
       "      <td>9.506678e+08</td>\n",
       "      <td>1.716994e+08</td>\n",
       "      <td>6921587.24</td>\n",
       "      <td>...</td>\n",
       "      <td>3.729017e+09</td>\n",
       "      <td>3.729017e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.3306</td>\n",
       "      <td>2.3306</td>\n",
       "      <td>0</td>\n",
       "      <td>3.729017e+09</td>\n",
       "      <td>3.729017e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20220331</td>\n",
       "      <td>元</td>\n",
       "      <td>8.841150e+09</td>\n",
       "      <td>8.841150e+09</td>\n",
       "      <td>6.503327e+09</td>\n",
       "      <td>5.864038e+09</td>\n",
       "      <td>3.662546e+07</td>\n",
       "      <td>3.626753e+08</td>\n",
       "      <td>7.206652e+07</td>\n",
       "      <td>7030684.83</td>\n",
       "      <td>...</td>\n",
       "      <td>1.922757e+09</td>\n",
       "      <td>1.922757e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.2017</td>\n",
       "      <td>1.2017</td>\n",
       "      <td>0</td>\n",
       "      <td>1.922757e+09</td>\n",
       "      <td>1.922757e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20211231</td>\n",
       "      <td>元</td>\n",
       "      <td>3.065242e+10</td>\n",
       "      <td>3.065242e+10</td>\n",
       "      <td>1.846648e+10</td>\n",
       "      <td>1.562180e+10</td>\n",
       "      <td>1.352342e+08</td>\n",
       "      <td>1.834807e+09</td>\n",
       "      <td>3.001955e+08</td>\n",
       "      <td>21821270.29</td>\n",
       "      <td>...</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.3803</td>\n",
       "      <td>6.3803</td>\n",
       "      <td>0</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       报表日期 单位       一、营业总收入          营业收入       二、营业总成本          营业成本  \\\n",
       "0  20221231  元  3.826401e+10  3.826401e+10  2.904984e+10  2.539550e+10   \n",
       "1  20220930  元  2.782329e+10  2.782329e+10  2.107379e+10  1.858638e+10   \n",
       "2  20220630  元  1.835375e+10  1.835375e+10  1.381560e+10  1.221367e+10   \n",
       "3  20220331  元  8.841150e+09  8.841150e+09  6.503327e+09  5.864038e+09   \n",
       "4  20211231  元  3.065242e+10  3.065242e+10  1.846648e+10  1.562180e+10   \n",
       "\n",
       "        营业税金及附加          销售费用          管理费用         财务费用  ...         五、净利润  \\\n",
       "0  1.770219e+08  2.235237e+09  3.741262e+08  13798317.84  ...  7.539000e+09   \n",
       "1  1.273912e+08  1.469335e+09  2.758392e+08   7344287.22  ...  5.607155e+09   \n",
       "2  8.491797e+07  9.506678e+08  1.716994e+08   6921587.24  ...  3.729017e+09   \n",
       "3  3.662546e+07  3.626753e+08  7.206652e+07   7030684.83  ...  1.922757e+09   \n",
       "4  1.352342e+08  1.834807e+09  3.001955e+08  21821270.29  ...  1.020855e+10   \n",
       "\n",
       "   归属于母公司所有者的净利润  少数股东损益  六、每股收益  基本每股收益(元/股)  稀释每股收益(元/股)  七、其他综合收益  \\\n",
       "0   7.539000e+09       0     NaN       4.7119       4.7119         0   \n",
       "1   5.607155e+09       0     NaN       3.5045       3.5045         0   \n",
       "2   3.729017e+09       0     NaN       2.3306       2.3306         0   \n",
       "3   1.922757e+09       0     NaN       1.2017       1.2017         0   \n",
       "4   1.020855e+10       0     NaN       6.3803       6.3803         0   \n",
       "\n",
       "       八、综合收益总额  归属于母公司所有者的综合收益总额  归属于少数股东的综合收益总额  \n",
       "0  7.539000e+09      7.539000e+09               0  \n",
       "1  5.607155e+09      5.607155e+09               0  \n",
       "2  3.729017e+09      3.729017e+09               0  \n",
       "3  1.922757e+09      1.922757e+09               0  \n",
       "4  1.020855e+10      1.020855e+10               0  \n",
       "\n",
       "[5 rows x 32 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_excel(r'C:/Users/86166/Desktop/python/test/利润表.xlsx')\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "f66b68d0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 57 entries, 0 to 56\n",
      "Data columns (total 32 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   报表日期                57 non-null     int64  \n",
      " 1   单位                  56 non-null     object \n",
      " 2   一、营业总收入             57 non-null     float64\n",
      " 3   营业收入                57 non-null     float64\n",
      " 4   二、营业总成本             57 non-null     float64\n",
      " 5   营业成本                57 non-null     float64\n",
      " 6   营业税金及附加             57 non-null     float64\n",
      " 7   销售费用                57 non-null     float64\n",
      " 8   管理费用                57 non-null     float64\n",
      " 9   财务费用                57 non-null     float64\n",
      " 10  研发费用                57 non-null     float64\n",
      " 11  资产减值损失              57 non-null     float64\n",
      " 12  公允价值变动收益            57 non-null     float64\n",
      " 13  投资收益                57 non-null     float64\n",
      " 14  其中:对联营企业和合营企业的投资收益  57 non-null     float64\n",
      " 15  汇兑收益                57 non-null     int64  \n",
      " 16  三、营业利润              57 non-null     float64\n",
      " 17  加:营业外收入             57 non-null     float64\n",
      " 18  减：营业外支出             57 non-null     float64\n",
      " 19  其中：非流动资产处置损失        57 non-null     float64\n",
      " 20  四、利润总额              57 non-null     float64\n",
      " 21  减：所得税费用             57 non-null     float64\n",
      " 22  五、净利润               57 non-null     float64\n",
      " 23  归属于母公司所有者的净利润       57 non-null     float64\n",
      " 24  少数股东损益              57 non-null     int64  \n",
      " 25  六、每股收益              0 non-null      float64\n",
      " 26  基本每股收益(元/股)         57 non-null     float64\n",
      " 27  稀释每股收益(元/股)         57 non-null     float64\n",
      " 28  七、其他综合收益            57 non-null     int64  \n",
      " 29  八、综合收益总额            57 non-null     float64\n",
      " 30  归属于母公司所有者的综合收益总额    57 non-null     float64\n",
      " 31  归属于少数股东的综合收益总额      57 non-null     int64  \n",
      "dtypes: float64(26), int64(5), object(1)\n",
      "memory usage: 14.4+ KB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "13c33470",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>报表日期</th>\n",
       "      <th>一、营业总收入</th>\n",
       "      <th>营业收入</th>\n",
       "      <th>二、营业总成本</th>\n",
       "      <th>营业成本</th>\n",
       "      <th>营业税金及附加</th>\n",
       "      <th>销售费用</th>\n",
       "      <th>管理费用</th>\n",
       "      <th>财务费用</th>\n",
       "      <th>研发费用</th>\n",
       "      <th>...</th>\n",
       "      <th>五、净利润</th>\n",
       "      <th>归属于母公司所有者的净利润</th>\n",
       "      <th>少数股东损益</th>\n",
       "      <th>六、每股收益</th>\n",
       "      <th>基本每股收益(元/股)</th>\n",
       "      <th>稀释每股收益(元/股)</th>\n",
       "      <th>七、其他综合收益</th>\n",
       "      <th>八、综合收益总额</th>\n",
       "      <th>归属于母公司所有者的综合收益总额</th>\n",
       "      <th>归属于少数股东的综合收益总额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>...</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>57.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57.000000</td>\n",
       "      <td>57.000000</td>\n",
       "      <td>57.0</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>5.700000e+01</td>\n",
       "      <td>57.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2.014729e+07</td>\n",
       "      <td>4.429169e+09</td>\n",
       "      <td>4.429169e+09</td>\n",
       "      <td>3.045621e+09</td>\n",
       "      <td>2.502890e+09</td>\n",
       "      <td>2.215811e+07</td>\n",
       "      <td>3.394805e+08</td>\n",
       "      <td>9.251387e+07</td>\n",
       "      <td>4.474118e+06</td>\n",
       "      <td>7.551454e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.150386e+09</td>\n",
       "      <td>1.150386e+09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.825154</td>\n",
       "      <td>0.825154</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.150386e+09</td>\n",
       "      <td>1.150386e+09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>7.303563e+04</td>\n",
       "      <td>8.242710e+09</td>\n",
       "      <td>8.242710e+09</td>\n",
       "      <td>5.781572e+09</td>\n",
       "      <td>5.046655e+09</td>\n",
       "      <td>3.680149e+07</td>\n",
       "      <td>4.785890e+08</td>\n",
       "      <td>7.637122e+07</td>\n",
       "      <td>3.174386e+07</td>\n",
       "      <td>1.673664e+08</td>\n",
       "      <td>...</td>\n",
       "      <td>2.199256e+09</td>\n",
       "      <td>2.199256e+09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.333321</td>\n",
       "      <td>1.333321</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.199256e+09</td>\n",
       "      <td>2.199256e+09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.970010e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>-3.310231e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2.012063e+07</td>\n",
       "      <td>3.804983e+08</td>\n",
       "      <td>3.804983e+08</td>\n",
       "      <td>2.489089e+08</td>\n",
       "      <td>1.024358e+08</td>\n",
       "      <td>3.504702e+06</td>\n",
       "      <td>7.215039e+07</td>\n",
       "      <td>3.559293e+07</td>\n",
       "      <td>-1.344091e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.022422e+08</td>\n",
       "      <td>1.022422e+08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.140000</td>\n",
       "      <td>0.140000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.022422e+08</td>\n",
       "      <td>1.022422e+08</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2.015123e+07</td>\n",
       "      <td>6.040475e+08</td>\n",
       "      <td>6.040475e+08</td>\n",
       "      <td>4.317369e+08</td>\n",
       "      <td>2.223132e+08</td>\n",
       "      <td>7.152259e+06</td>\n",
       "      <td>1.287736e+08</td>\n",
       "      <td>7.206652e+07</td>\n",
       "      <td>-2.811938e+06</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.731210e+08</td>\n",
       "      <td>1.731210e+08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.330000</td>\n",
       "      <td>0.330000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.731210e+08</td>\n",
       "      <td>1.731210e+08</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2.019063e+07</td>\n",
       "      <td>3.926601e+09</td>\n",
       "      <td>3.926601e+09</td>\n",
       "      <td>2.756079e+09</td>\n",
       "      <td>2.318670e+09</td>\n",
       "      <td>1.769687e+07</td>\n",
       "      <td>3.626753e+08</td>\n",
       "      <td>1.267347e+08</td>\n",
       "      <td>7.344287e+06</td>\n",
       "      <td>6.738487e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.086588e+09</td>\n",
       "      <td>1.086588e+09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.690000</td>\n",
       "      <td>0.690000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.086588e+09</td>\n",
       "      <td>1.086588e+09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2.022123e+07</td>\n",
       "      <td>3.826401e+10</td>\n",
       "      <td>3.826401e+10</td>\n",
       "      <td>2.904984e+10</td>\n",
       "      <td>2.539550e+10</td>\n",
       "      <td>1.770219e+08</td>\n",
       "      <td>2.235237e+09</td>\n",
       "      <td>3.741262e+08</td>\n",
       "      <td>1.313844e+08</td>\n",
       "      <td>8.541613e+08</td>\n",
       "      <td>...</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.380300</td>\n",
       "      <td>6.380300</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               报表日期       一、营业总收入          营业收入       二、营业总成本          营业成本  \\\n",
       "count  5.700000e+01  5.700000e+01  5.700000e+01  5.700000e+01  5.700000e+01   \n",
       "mean   2.014729e+07  4.429169e+09  4.429169e+09  3.045621e+09  2.502890e+09   \n",
       "std    7.303563e+04  8.242710e+09  8.242710e+09  5.781572e+09  5.046655e+09   \n",
       "min    1.970010e+07  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "25%    2.012063e+07  3.804983e+08  3.804983e+08  2.489089e+08  1.024358e+08   \n",
       "50%    2.015123e+07  6.040475e+08  6.040475e+08  4.317369e+08  2.223132e+08   \n",
       "75%    2.019063e+07  3.926601e+09  3.926601e+09  2.756079e+09  2.318670e+09   \n",
       "max    2.022123e+07  3.826401e+10  3.826401e+10  2.904984e+10  2.539550e+10   \n",
       "\n",
       "            营业税金及附加          销售费用          管理费用          财务费用          研发费用  \\\n",
       "count  5.700000e+01  5.700000e+01  5.700000e+01  5.700000e+01  5.700000e+01   \n",
       "mean   2.215811e+07  3.394805e+08  9.251387e+07  4.474118e+06  7.551454e+07   \n",
       "std    3.680149e+07  4.785890e+08  7.637122e+07  3.174386e+07  1.673664e+08   \n",
       "min    0.000000e+00  0.000000e+00  0.000000e+00 -3.310231e+07  0.000000e+00   \n",
       "25%    3.504702e+06  7.215039e+07  3.559293e+07 -1.344091e+07  0.000000e+00   \n",
       "50%    7.152259e+06  1.287736e+08  7.206652e+07 -2.811938e+06  0.000000e+00   \n",
       "75%    1.769687e+07  3.626753e+08  1.267347e+08  7.344287e+06  6.738487e+07   \n",
       "max    1.770219e+08  2.235237e+09  3.741262e+08  1.313844e+08  8.541613e+08   \n",
       "\n",
       "       ...         五、净利润  归属于母公司所有者的净利润  少数股东损益  六、每股收益  基本每股收益(元/股)  \\\n",
       "count  ...  5.700000e+01   5.700000e+01    57.0     0.0    57.000000   \n",
       "mean   ...  1.150386e+09   1.150386e+09     0.0     NaN     0.825154   \n",
       "std    ...  2.199256e+09   2.199256e+09     0.0     NaN     1.333321   \n",
       "min    ...  0.000000e+00   0.000000e+00     0.0     NaN     0.000000   \n",
       "25%    ...  1.022422e+08   1.022422e+08     0.0     NaN     0.140000   \n",
       "50%    ...  1.731210e+08   1.731210e+08     0.0     NaN     0.330000   \n",
       "75%    ...  1.086588e+09   1.086588e+09     0.0     NaN     0.690000   \n",
       "max    ...  1.020855e+10   1.020855e+10     0.0     NaN     6.380300   \n",
       "\n",
       "       稀释每股收益(元/股)  七、其他综合收益      八、综合收益总额  归属于母公司所有者的综合收益总额  归属于少数股东的综合收益总额  \n",
       "count    57.000000      57.0  5.700000e+01      5.700000e+01            57.0  \n",
       "mean      0.825154       0.0  1.150386e+09      1.150386e+09             0.0  \n",
       "std       1.333321       0.0  2.199256e+09      2.199256e+09             0.0  \n",
       "min       0.000000       0.0  0.000000e+00      0.000000e+00             0.0  \n",
       "25%       0.140000       0.0  1.022422e+08      1.022422e+08             0.0  \n",
       "50%       0.330000       0.0  1.731210e+08      1.731210e+08             0.0  \n",
       "75%       0.690000       0.0  1.086588e+09      1.086588e+09             0.0  \n",
       "max       6.380300       0.0  1.020855e+10      1.020855e+10             0.0  \n",
       "\n",
       "[8 rows x 31 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "cc8a6a8f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "报表日期                  False\n",
       "单位                     True\n",
       "一、营业总收入               False\n",
       "营业收入                  False\n",
       "二、营业总成本               False\n",
       "营业成本                  False\n",
       "营业税金及附加               False\n",
       "销售费用                  False\n",
       "管理费用                  False\n",
       "财务费用                  False\n",
       "研发费用                  False\n",
       "资产减值损失                False\n",
       "公允价值变动收益              False\n",
       "投资收益                  False\n",
       "其中:对联营企业和合营企业的投资收益    False\n",
       "汇兑收益                  False\n",
       "三、营业利润                False\n",
       "加:营业外收入               False\n",
       "减：营业外支出               False\n",
       "其中：非流动资产处置损失          False\n",
       "四、利润总额                False\n",
       "减：所得税费用               False\n",
       "五、净利润                 False\n",
       "归属于母公司所有者的净利润         False\n",
       "少数股东损益                False\n",
       "六、每股收益                 True\n",
       "基本每股收益(元/股)           False\n",
       "稀释每股收益(元/股)           False\n",
       "七、其他综合收益              False\n",
       "八、综合收益总额              False\n",
       "归属于母公司所有者的综合收益总额      False\n",
       "归属于少数股东的综合收益总额        False\n",
       "dtype: bool"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().any(axis=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "bc644c4a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     True\n",
       "1     True\n",
       "2     True\n",
       "3     True\n",
       "4     True\n",
       "5     True\n",
       "6     True\n",
       "7     True\n",
       "8     True\n",
       "9     True\n",
       "10    True\n",
       "11    True\n",
       "12    True\n",
       "13    True\n",
       "14    True\n",
       "15    True\n",
       "16    True\n",
       "17    True\n",
       "18    True\n",
       "19    True\n",
       "20    True\n",
       "21    True\n",
       "22    True\n",
       "23    True\n",
       "24    True\n",
       "25    True\n",
       "26    True\n",
       "27    True\n",
       "28    True\n",
       "29    True\n",
       "30    True\n",
       "31    True\n",
       "32    True\n",
       "33    True\n",
       "34    True\n",
       "35    True\n",
       "36    True\n",
       "37    True\n",
       "38    True\n",
       "39    True\n",
       "40    True\n",
       "41    True\n",
       "42    True\n",
       "43    True\n",
       "44    True\n",
       "45    True\n",
       "46    True\n",
       "47    True\n",
       "48    True\n",
       "49    True\n",
       "50    True\n",
       "51    True\n",
       "52    True\n",
       "53    True\n",
       "54    True\n",
       "55    True\n",
       "56    True\n",
       "dtype: bool"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().any(axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "0af59c2b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>报表日期</th>\n",
       "      <th>单位</th>\n",
       "      <th>一、营业总收入</th>\n",
       "      <th>营业收入</th>\n",
       "      <th>二、营业总成本</th>\n",
       "      <th>营业成本</th>\n",
       "      <th>营业税金及附加</th>\n",
       "      <th>销售费用</th>\n",
       "      <th>管理费用</th>\n",
       "      <th>财务费用</th>\n",
       "      <th>...</th>\n",
       "      <th>五、净利润</th>\n",
       "      <th>归属于母公司所有者的净利润</th>\n",
       "      <th>少数股东损益</th>\n",
       "      <th>六、每股收益</th>\n",
       "      <th>基本每股收益(元/股)</th>\n",
       "      <th>稀释每股收益(元/股)</th>\n",
       "      <th>七、其他综合收益</th>\n",
       "      <th>八、综合收益总额</th>\n",
       "      <th>归属于母公司所有者的综合收益总额</th>\n",
       "      <th>归属于少数股东的综合收益总额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20221231</td>\n",
       "      <td>元</td>\n",
       "      <td>3.826401e+10</td>\n",
       "      <td>3.826401e+10</td>\n",
       "      <td>2.904984e+10</td>\n",
       "      <td>2.539550e+10</td>\n",
       "      <td>1.770219e+08</td>\n",
       "      <td>2.235237e+09</td>\n",
       "      <td>3.741262e+08</td>\n",
       "      <td>1.379832e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>7.539000e+09</td>\n",
       "      <td>7.539000e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.7119</td>\n",
       "      <td>4.7119</td>\n",
       "      <td>0</td>\n",
       "      <td>7.539000e+09</td>\n",
       "      <td>7.539000e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20220930</td>\n",
       "      <td>元</td>\n",
       "      <td>2.782329e+10</td>\n",
       "      <td>2.782329e+10</td>\n",
       "      <td>2.107379e+10</td>\n",
       "      <td>1.858638e+10</td>\n",
       "      <td>1.273912e+08</td>\n",
       "      <td>1.469335e+09</td>\n",
       "      <td>2.758392e+08</td>\n",
       "      <td>7.344287e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>5.607155e+09</td>\n",
       "      <td>5.607155e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.5045</td>\n",
       "      <td>3.5045</td>\n",
       "      <td>0</td>\n",
       "      <td>5.607155e+09</td>\n",
       "      <td>5.607155e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20220630</td>\n",
       "      <td>元</td>\n",
       "      <td>1.835375e+10</td>\n",
       "      <td>1.835375e+10</td>\n",
       "      <td>1.381560e+10</td>\n",
       "      <td>1.221367e+10</td>\n",
       "      <td>8.491797e+07</td>\n",
       "      <td>9.506678e+08</td>\n",
       "      <td>1.716994e+08</td>\n",
       "      <td>6.921587e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>3.729017e+09</td>\n",
       "      <td>3.729017e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.3306</td>\n",
       "      <td>2.3306</td>\n",
       "      <td>0</td>\n",
       "      <td>3.729017e+09</td>\n",
       "      <td>3.729017e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20220331</td>\n",
       "      <td>元</td>\n",
       "      <td>8.841150e+09</td>\n",
       "      <td>8.841150e+09</td>\n",
       "      <td>6.503327e+09</td>\n",
       "      <td>5.864038e+09</td>\n",
       "      <td>3.662546e+07</td>\n",
       "      <td>3.626753e+08</td>\n",
       "      <td>7.206652e+07</td>\n",
       "      <td>7.030685e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.922757e+09</td>\n",
       "      <td>1.922757e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.2017</td>\n",
       "      <td>1.2017</td>\n",
       "      <td>0</td>\n",
       "      <td>1.922757e+09</td>\n",
       "      <td>1.922757e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20211231</td>\n",
       "      <td>元</td>\n",
       "      <td>3.065242e+10</td>\n",
       "      <td>3.065242e+10</td>\n",
       "      <td>1.846648e+10</td>\n",
       "      <td>1.562180e+10</td>\n",
       "      <td>1.352342e+08</td>\n",
       "      <td>1.834807e+09</td>\n",
       "      <td>3.001955e+08</td>\n",
       "      <td>2.182127e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.3803</td>\n",
       "      <td>6.3803</td>\n",
       "      <td>0</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>20210930</td>\n",
       "      <td>元</td>\n",
       "      <td>2.182866e+10</td>\n",
       "      <td>2.182866e+10</td>\n",
       "      <td>1.182180e+10</td>\n",
       "      <td>1.003811e+10</td>\n",
       "      <td>9.743332e+07</td>\n",
       "      <td>1.225365e+09</td>\n",
       "      <td>2.008999e+08</td>\n",
       "      <td>1.965119e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>8.403608e+09</td>\n",
       "      <td>8.403608e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.2523</td>\n",
       "      <td>5.2523</td>\n",
       "      <td>0</td>\n",
       "      <td>8.403608e+09</td>\n",
       "      <td>8.403608e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>20210630</td>\n",
       "      <td>元</td>\n",
       "      <td>1.317148e+10</td>\n",
       "      <td>1.317148e+10</td>\n",
       "      <td>6.662966e+09</td>\n",
       "      <td>5.491862e+09</td>\n",
       "      <td>6.201584e+07</td>\n",
       "      <td>7.781028e+08</td>\n",
       "      <td>1.290693e+08</td>\n",
       "      <td>3.918659e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>5.490650e+09</td>\n",
       "      <td>5.490650e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.4317</td>\n",
       "      <td>3.4317</td>\n",
       "      <td>0</td>\n",
       "      <td>5.490650e+09</td>\n",
       "      <td>5.490650e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>20210331</td>\n",
       "      <td>元</td>\n",
       "      <td>3.926601e+09</td>\n",
       "      <td>3.926601e+09</td>\n",
       "      <td>2.756079e+09</td>\n",
       "      <td>2.318670e+09</td>\n",
       "      <td>1.638660e+07</td>\n",
       "      <td>2.719420e+08</td>\n",
       "      <td>5.710977e+07</td>\n",
       "      <td>3.035498e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>9.381791e+08</td>\n",
       "      <td>9.381791e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5864</td>\n",
       "      <td>0.5864</td>\n",
       "      <td>0</td>\n",
       "      <td>9.381791e+08</td>\n",
       "      <td>9.381791e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>20201231</td>\n",
       "      <td>元</td>\n",
       "      <td>1.519037e+10</td>\n",
       "      <td>1.519037e+10</td>\n",
       "      <td>1.117980e+10</td>\n",
       "      <td>9.268009e+09</td>\n",
       "      <td>7.098972e+07</td>\n",
       "      <td>1.197507e+09</td>\n",
       "      <td>2.122592e+08</td>\n",
       "      <td>1.313844e+08</td>\n",
       "      <td>...</td>\n",
       "      <td>3.301327e+09</td>\n",
       "      <td>3.301327e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0633</td>\n",
       "      <td>2.0633</td>\n",
       "      <td>0</td>\n",
       "      <td>3.301327e+09</td>\n",
       "      <td>3.301327e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>20200930</td>\n",
       "      <td>元</td>\n",
       "      <td>1.104979e+10</td>\n",
       "      <td>1.104979e+10</td>\n",
       "      <td>7.969426e+09</td>\n",
       "      <td>6.627694e+09</td>\n",
       "      <td>4.983327e+07</td>\n",
       "      <td>8.189057e+08</td>\n",
       "      <td>1.415956e+08</td>\n",
       "      <td>1.104116e+08</td>\n",
       "      <td>...</td>\n",
       "      <td>2.478596e+09</td>\n",
       "      <td>2.478596e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.5491</td>\n",
       "      <td>1.5491</td>\n",
       "      <td>0</td>\n",
       "      <td>2.478596e+09</td>\n",
       "      <td>2.478596e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>20200630</td>\n",
       "      <td>元</td>\n",
       "      <td>6.993723e+09</td>\n",
       "      <td>6.993723e+09</td>\n",
       "      <td>5.036619e+09</td>\n",
       "      <td>4.303097e+09</td>\n",
       "      <td>3.269298e+07</td>\n",
       "      <td>4.294139e+08</td>\n",
       "      <td>9.254171e+07</td>\n",
       "      <td>7.282094e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.504548e+09</td>\n",
       "      <td>1.504548e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9403</td>\n",
       "      <td>0.9403</td>\n",
       "      <td>0</td>\n",
       "      <td>1.504548e+09</td>\n",
       "      <td>1.504548e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>20200331</td>\n",
       "      <td>元</td>\n",
       "      <td>2.634599e+09</td>\n",
       "      <td>2.634599e+09</td>\n",
       "      <td>1.939468e+09</td>\n",
       "      <td>1.657523e+09</td>\n",
       "      <td>1.127358e+07</td>\n",
       "      <td>1.366930e+08</td>\n",
       "      <td>4.782170e+07</td>\n",
       "      <td>3.870799e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>5.163634e+08</td>\n",
       "      <td>5.163634e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3227</td>\n",
       "      <td>0.3227</td>\n",
       "      <td>0</td>\n",
       "      <td>5.163634e+08</td>\n",
       "      <td>5.163634e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>20191231</td>\n",
       "      <td>元</td>\n",
       "      <td>1.058732e+10</td>\n",
       "      <td>1.058732e+10</td>\n",
       "      <td>7.709980e+09</td>\n",
       "      <td>6.135815e+09</td>\n",
       "      <td>5.141446e+07</td>\n",
       "      <td>1.095580e+09</td>\n",
       "      <td>1.826917e+08</td>\n",
       "      <td>7.492645e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>2.366439e+09</td>\n",
       "      <td>2.366439e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.4790</td>\n",
       "      <td>1.4790</td>\n",
       "      <td>0</td>\n",
       "      <td>2.366439e+09</td>\n",
       "      <td>2.366439e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>20190930</td>\n",
       "      <td>元</td>\n",
       "      <td>7.666171e+09</td>\n",
       "      <td>7.666171e+09</td>\n",
       "      <td>5.475325e+09</td>\n",
       "      <td>4.450911e+09</td>\n",
       "      <td>3.538434e+07</td>\n",
       "      <td>7.086295e+08</td>\n",
       "      <td>1.262015e+08</td>\n",
       "      <td>4.967168e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.762941e+09</td>\n",
       "      <td>1.762941e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.1018</td>\n",
       "      <td>1.1018</td>\n",
       "      <td>0</td>\n",
       "      <td>1.762941e+09</td>\n",
       "      <td>1.762941e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>20190630</td>\n",
       "      <td>元</td>\n",
       "      <td>5.038678e+09</td>\n",
       "      <td>5.038678e+09</td>\n",
       "      <td>3.600468e+09</td>\n",
       "      <td>2.964282e+09</td>\n",
       "      <td>2.447402e+07</td>\n",
       "      <td>4.394425e+08</td>\n",
       "      <td>7.973578e+07</td>\n",
       "      <td>2.514876e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.146970e+09</td>\n",
       "      <td>1.146970e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7169</td>\n",
       "      <td>0.7169</td>\n",
       "      <td>0</td>\n",
       "      <td>1.146970e+09</td>\n",
       "      <td>1.146970e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>20190331</td>\n",
       "      <td>元</td>\n",
       "      <td>2.293537e+09</td>\n",
       "      <td>2.293537e+09</td>\n",
       "      <td>1.673250e+09</td>\n",
       "      <td>1.378965e+09</td>\n",
       "      <td>9.417647e+06</td>\n",
       "      <td>1.640910e+08</td>\n",
       "      <td>4.015490e+07</td>\n",
       "      <td>1.023333e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>5.020661e+08</td>\n",
       "      <td>5.020661e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3138</td>\n",
       "      <td>0.3138</td>\n",
       "      <td>0</td>\n",
       "      <td>5.020661e+08</td>\n",
       "      <td>5.020661e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>20181231</td>\n",
       "      <td>元</td>\n",
       "      <td>5.228308e+09</td>\n",
       "      <td>5.228308e+09</td>\n",
       "      <td>3.527055e+09</td>\n",
       "      <td>2.364930e+09</td>\n",
       "      <td>2.838358e+07</td>\n",
       "      <td>7.653167e+08</td>\n",
       "      <td>1.335025e+08</td>\n",
       "      <td>1.816713e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.451367e+09</td>\n",
       "      <td>1.451367e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9071</td>\n",
       "      <td>0.9071</td>\n",
       "      <td>0</td>\n",
       "      <td>1.451367e+09</td>\n",
       "      <td>1.451367e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>20180930</td>\n",
       "      <td>元</td>\n",
       "      <td>3.494879e+09</td>\n",
       "      <td>3.494879e+09</td>\n",
       "      <td>2.210957e+09</td>\n",
       "      <td>1.507394e+09</td>\n",
       "      <td>1.769687e+07</td>\n",
       "      <td>4.721613e+08</td>\n",
       "      <td>1.839704e+08</td>\n",
       "      <td>6.834894e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.086588e+09</td>\n",
       "      <td>1.086588e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6791</td>\n",
       "      <td>0.6791</td>\n",
       "      <td>0</td>\n",
       "      <td>1.086588e+09</td>\n",
       "      <td>1.086588e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>20180630</td>\n",
       "      <td>元</td>\n",
       "      <td>2.071876e+09</td>\n",
       "      <td>2.071876e+09</td>\n",
       "      <td>1.270661e+09</td>\n",
       "      <td>8.453442e+08</td>\n",
       "      <td>1.191289e+07</td>\n",
       "      <td>2.941416e+08</td>\n",
       "      <td>1.045435e+08</td>\n",
       "      <td>1.777847e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>6.823785e+08</td>\n",
       "      <td>6.823785e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.4265</td>\n",
       "      <td>0.4265</td>\n",
       "      <td>0</td>\n",
       "      <td>6.823785e+08</td>\n",
       "      <td>6.823785e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20180331</td>\n",
       "      <td>元</td>\n",
       "      <td>8.383283e+08</td>\n",
       "      <td>8.383283e+08</td>\n",
       "      <td>5.301718e+08</td>\n",
       "      <td>3.775706e+08</td>\n",
       "      <td>3.446958e+06</td>\n",
       "      <td>8.700206e+07</td>\n",
       "      <td>5.381581e+07</td>\n",
       "      <td>3.132290e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>2.596324e+08</td>\n",
       "      <td>2.596324e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1623</td>\n",
       "      <td>0.1623</td>\n",
       "      <td>0</td>\n",
       "      <td>2.596324e+08</td>\n",
       "      <td>2.596324e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20171231</td>\n",
       "      <td>元</td>\n",
       "      <td>1.342569e+09</td>\n",
       "      <td>1.342569e+09</td>\n",
       "      <td>8.372390e+08</td>\n",
       "      <td>2.880615e+08</td>\n",
       "      <td>1.219603e+07</td>\n",
       "      <td>3.143401e+08</td>\n",
       "      <td>1.873274e+08</td>\n",
       "      <td>-1.209225e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>4.322754e+08</td>\n",
       "      <td>4.322754e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2700</td>\n",
       "      <td>0.2700</td>\n",
       "      <td>0</td>\n",
       "      <td>4.322754e+08</td>\n",
       "      <td>4.322754e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>20170930</td>\n",
       "      <td>元</td>\n",
       "      <td>7.690548e+08</td>\n",
       "      <td>7.690548e+08</td>\n",
       "      <td>4.441503e+08</td>\n",
       "      <td>9.245599e+07</td>\n",
       "      <td>6.689791e+06</td>\n",
       "      <td>1.885112e+08</td>\n",
       "      <td>1.267347e+08</td>\n",
       "      <td>-6.744314e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>2.852348e+08</td>\n",
       "      <td>2.852348e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1783</td>\n",
       "      <td>0.1783</td>\n",
       "      <td>0</td>\n",
       "      <td>2.852348e+08</td>\n",
       "      <td>2.852348e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>20170630</td>\n",
       "      <td>元</td>\n",
       "      <td>4.451620e+08</td>\n",
       "      <td>4.451620e+08</td>\n",
       "      <td>2.489089e+08</td>\n",
       "      <td>3.444997e+07</td>\n",
       "      <td>5.166075e+06</td>\n",
       "      <td>1.069302e+08</td>\n",
       "      <td>7.909058e+07</td>\n",
       "      <td>-6.392373e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.717901e+08</td>\n",
       "      <td>1.717901e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0</td>\n",
       "      <td>1.717901e+08</td>\n",
       "      <td>1.717901e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>20170331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.622370e+08</td>\n",
       "      <td>1.622370e+08</td>\n",
       "      <td>9.485878e+07</td>\n",
       "      <td>1.002407e+07</td>\n",
       "      <td>6.873437e+05</td>\n",
       "      <td>3.454272e+07</td>\n",
       "      <td>3.897243e+07</td>\n",
       "      <td>-2.811938e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>6.031745e+07</td>\n",
       "      <td>6.031745e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0400</td>\n",
       "      <td>0.0400</td>\n",
       "      <td>0</td>\n",
       "      <td>6.031745e+07</td>\n",
       "      <td>6.031745e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>20161231</td>\n",
       "      <td>元</td>\n",
       "      <td>4.459472e+08</td>\n",
       "      <td>4.459472e+08</td>\n",
       "      <td>4.163816e+08</td>\n",
       "      <td>3.521882e+07</td>\n",
       "      <td>5.538279e+06</td>\n",
       "      <td>2.016168e+08</td>\n",
       "      <td>1.543616e+08</td>\n",
       "      <td>-1.845406e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>3.252031e+07</td>\n",
       "      <td>3.252031e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0200</td>\n",
       "      <td>0.0200</td>\n",
       "      <td>0</td>\n",
       "      <td>3.252031e+07</td>\n",
       "      <td>3.252031e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>20160930</td>\n",
       "      <td>元</td>\n",
       "      <td>2.732335e+08</td>\n",
       "      <td>2.732335e+08</td>\n",
       "      <td>2.724444e+08</td>\n",
       "      <td>1.987151e+07</td>\n",
       "      <td>1.156749e+06</td>\n",
       "      <td>1.287736e+08</td>\n",
       "      <td>1.051396e+08</td>\n",
       "      <td>-1.401248e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>6.761262e+06</td>\n",
       "      <td>6.761262e+06</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0042</td>\n",
       "      <td>0.0042</td>\n",
       "      <td>0</td>\n",
       "      <td>6.761262e+06</td>\n",
       "      <td>6.761262e+06</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>20160630</td>\n",
       "      <td>元</td>\n",
       "      <td>1.839440e+08</td>\n",
       "      <td>1.839440e+08</td>\n",
       "      <td>1.748111e+08</td>\n",
       "      <td>1.653117e+07</td>\n",
       "      <td>6.061102e+05</td>\n",
       "      <td>7.744687e+07</td>\n",
       "      <td>6.725415e+07</td>\n",
       "      <td>-9.199014e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.203886e+07</td>\n",
       "      <td>1.203886e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>0</td>\n",
       "      <td>1.203886e+07</td>\n",
       "      <td>1.203886e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>20160331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.437181e+08</td>\n",
       "      <td>1.437181e+08</td>\n",
       "      <td>7.716280e+07</td>\n",
       "      <td>9.824917e+06</td>\n",
       "      <td>5.782926e+05</td>\n",
       "      <td>2.779000e+07</td>\n",
       "      <td>3.405929e+07</td>\n",
       "      <td>-4.364309e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>5.919843e+07</td>\n",
       "      <td>5.919843e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>0</td>\n",
       "      <td>5.919843e+07</td>\n",
       "      <td>5.919843e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>20151231</td>\n",
       "      <td>元</td>\n",
       "      <td>7.127381e+08</td>\n",
       "      <td>7.127381e+08</td>\n",
       "      <td>4.943913e+08</td>\n",
       "      <td>1.417646e+08</td>\n",
       "      <td>4.710302e+06</td>\n",
       "      <td>2.391420e+08</td>\n",
       "      <td>1.258705e+08</td>\n",
       "      <td>-2.759567e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.974019e+08</td>\n",
       "      <td>1.974019e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2500</td>\n",
       "      <td>0.2500</td>\n",
       "      <td>0</td>\n",
       "      <td>1.974019e+08</td>\n",
       "      <td>1.974019e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>20150930</td>\n",
       "      <td>元</td>\n",
       "      <td>5.552421e+08</td>\n",
       "      <td>5.552421e+08</td>\n",
       "      <td>3.745873e+08</td>\n",
       "      <td>1.295146e+08</td>\n",
       "      <td>3.145295e+06</td>\n",
       "      <td>1.598761e+08</td>\n",
       "      <td>8.937196e+07</td>\n",
       "      <td>-2.026475e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.604950e+08</td>\n",
       "      <td>1.604950e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2000</td>\n",
       "      <td>0.2000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.604950e+08</td>\n",
       "      <td>1.604950e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>20150630</td>\n",
       "      <td>元</td>\n",
       "      <td>3.846178e+08</td>\n",
       "      <td>3.846178e+08</td>\n",
       "      <td>2.605976e+08</td>\n",
       "      <td>1.122350e+08</td>\n",
       "      <td>2.376026e+06</td>\n",
       "      <td>9.427485e+07</td>\n",
       "      <td>5.650317e+07</td>\n",
       "      <td>-1.266529e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.081221e+08</td>\n",
       "      <td>1.081221e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1400</td>\n",
       "      <td>0.1400</td>\n",
       "      <td>0</td>\n",
       "      <td>1.081221e+08</td>\n",
       "      <td>1.081221e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>20150331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.964726e+08</td>\n",
       "      <td>1.964726e+08</td>\n",
       "      <td>1.430482e+08</td>\n",
       "      <td>7.867512e+07</td>\n",
       "      <td>1.049326e+06</td>\n",
       "      <td>3.730860e+07</td>\n",
       "      <td>2.787392e+07</td>\n",
       "      <td>-6.311175e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>4.770840e+07</td>\n",
       "      <td>4.770840e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0600</td>\n",
       "      <td>0.0600</td>\n",
       "      <td>0</td>\n",
       "      <td>4.770840e+07</td>\n",
       "      <td>4.770840e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>20141231</td>\n",
       "      <td>元</td>\n",
       "      <td>8.009375e+08</td>\n",
       "      <td>8.009375e+08</td>\n",
       "      <td>6.283652e+08</td>\n",
       "      <td>3.107933e+08</td>\n",
       "      <td>7.097341e+06</td>\n",
       "      <td>2.106387e+08</td>\n",
       "      <td>1.115840e+08</td>\n",
       "      <td>-2.458272e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.480040e+08</td>\n",
       "      <td>1.480040e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1900</td>\n",
       "      <td>0.1900</td>\n",
       "      <td>0</td>\n",
       "      <td>1.480040e+08</td>\n",
       "      <td>1.480040e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>20140930</td>\n",
       "      <td>元</td>\n",
       "      <td>5.772012e+08</td>\n",
       "      <td>5.772012e+08</td>\n",
       "      <td>4.181663e+08</td>\n",
       "      <td>2.223132e+08</td>\n",
       "      <td>4.984528e+06</td>\n",
       "      <td>1.206588e+08</td>\n",
       "      <td>7.484325e+07</td>\n",
       "      <td>-1.842650e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.369069e+08</td>\n",
       "      <td>1.369069e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1700</td>\n",
       "      <td>0.1700</td>\n",
       "      <td>0</td>\n",
       "      <td>1.369069e+08</td>\n",
       "      <td>1.369069e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>20140630</td>\n",
       "      <td>元</td>\n",
       "      <td>3.804983e+08</td>\n",
       "      <td>3.804983e+08</td>\n",
       "      <td>2.685228e+08</td>\n",
       "      <td>1.460294e+08</td>\n",
       "      <td>3.646606e+06</td>\n",
       "      <td>6.970584e+07</td>\n",
       "      <td>4.988302e+07</td>\n",
       "      <td>-1.338157e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>9.587459e+07</td>\n",
       "      <td>9.587459e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1200</td>\n",
       "      <td>0.1200</td>\n",
       "      <td>0</td>\n",
       "      <td>9.587459e+07</td>\n",
       "      <td>9.587459e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>20140331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.626753e+08</td>\n",
       "      <td>1.626753e+08</td>\n",
       "      <td>1.130584e+08</td>\n",
       "      <td>6.820405e+07</td>\n",
       "      <td>1.359633e+06</td>\n",
       "      <td>1.997322e+07</td>\n",
       "      <td>2.598349e+07</td>\n",
       "      <td>-6.084446e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>4.259445e+07</td>\n",
       "      <td>4.259445e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0</td>\n",
       "      <td>4.259445e+07</td>\n",
       "      <td>4.259445e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>20131231</td>\n",
       "      <td>元</td>\n",
       "      <td>7.801779e+08</td>\n",
       "      <td>7.801779e+08</td>\n",
       "      <td>6.337309e+08</td>\n",
       "      <td>3.080549e+08</td>\n",
       "      <td>8.305535e+06</td>\n",
       "      <td>1.489785e+08</td>\n",
       "      <td>1.523629e+08</td>\n",
       "      <td>-2.501208e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.303478e+08</td>\n",
       "      <td>1.303478e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3300</td>\n",
       "      <td>0.3300</td>\n",
       "      <td>0</td>\n",
       "      <td>1.303478e+08</td>\n",
       "      <td>1.303478e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>20130930</td>\n",
       "      <td>元</td>\n",
       "      <td>5.802861e+08</td>\n",
       "      <td>5.802861e+08</td>\n",
       "      <td>4.317369e+08</td>\n",
       "      <td>2.471864e+08</td>\n",
       "      <td>5.599594e+06</td>\n",
       "      <td>9.909023e+07</td>\n",
       "      <td>8.863074e+07</td>\n",
       "      <td>-1.855409e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.315284e+08</td>\n",
       "      <td>1.315284e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3300</td>\n",
       "      <td>0.3300</td>\n",
       "      <td>0</td>\n",
       "      <td>1.315284e+08</td>\n",
       "      <td>1.315284e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>20130630</td>\n",
       "      <td>元</td>\n",
       "      <td>4.255763e+08</td>\n",
       "      <td>4.255763e+08</td>\n",
       "      <td>3.088316e+08</td>\n",
       "      <td>1.883981e+08</td>\n",
       "      <td>4.172664e+06</td>\n",
       "      <td>5.953447e+07</td>\n",
       "      <td>6.397482e+07</td>\n",
       "      <td>-1.510489e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.022422e+08</td>\n",
       "      <td>1.022422e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2600</td>\n",
       "      <td>0.2600</td>\n",
       "      <td>0</td>\n",
       "      <td>1.022422e+08</td>\n",
       "      <td>1.022422e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>20130331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.845495e+08</td>\n",
       "      <td>1.845495e+08</td>\n",
       "      <td>1.380217e+08</td>\n",
       "      <td>9.368991e+07</td>\n",
       "      <td>1.639516e+06</td>\n",
       "      <td>2.354024e+07</td>\n",
       "      <td>2.209933e+07</td>\n",
       "      <td>-5.888346e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>4.130339e+07</td>\n",
       "      <td>4.130339e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1000</td>\n",
       "      <td>0.1000</td>\n",
       "      <td>0</td>\n",
       "      <td>4.130339e+07</td>\n",
       "      <td>4.130339e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>20121231</td>\n",
       "      <td>元</td>\n",
       "      <td>7.646197e+08</td>\n",
       "      <td>7.646197e+08</td>\n",
       "      <td>5.491002e+08</td>\n",
       "      <td>3.382518e+08</td>\n",
       "      <td>7.152259e+06</td>\n",
       "      <td>1.488400e+08</td>\n",
       "      <td>8.465827e+07</td>\n",
       "      <td>-3.124095e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>2.179439e+08</td>\n",
       "      <td>2.179439e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5400</td>\n",
       "      <td>0.5400</td>\n",
       "      <td>0</td>\n",
       "      <td>2.179439e+08</td>\n",
       "      <td>2.179439e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>20120930</td>\n",
       "      <td>元</td>\n",
       "      <td>4.969606e+08</td>\n",
       "      <td>4.969606e+08</td>\n",
       "      <td>3.682727e+08</td>\n",
       "      <td>2.245410e+08</td>\n",
       "      <td>4.730511e+06</td>\n",
       "      <td>1.020268e+08</td>\n",
       "      <td>5.560137e+07</td>\n",
       "      <td>-2.383421e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.437329e+08</td>\n",
       "      <td>1.437329e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3600</td>\n",
       "      <td>0.3600</td>\n",
       "      <td>0</td>\n",
       "      <td>1.437329e+08</td>\n",
       "      <td>1.437329e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>20120630</td>\n",
       "      <td>元</td>\n",
       "      <td>3.279894e+08</td>\n",
       "      <td>3.279894e+08</td>\n",
       "      <td>2.379716e+08</td>\n",
       "      <td>1.554276e+08</td>\n",
       "      <td>3.504702e+06</td>\n",
       "      <td>5.362713e+07</td>\n",
       "      <td>3.534834e+07</td>\n",
       "      <td>-1.344091e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.085375e+08</td>\n",
       "      <td>1.085375e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2700</td>\n",
       "      <td>0.2700</td>\n",
       "      <td>0</td>\n",
       "      <td>1.085375e+08</td>\n",
       "      <td>1.085375e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>20120331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.385710e+08</td>\n",
       "      <td>1.385710e+08</td>\n",
       "      <td>9.805952e+07</td>\n",
       "      <td>6.784050e+07</td>\n",
       "      <td>9.815469e+05</td>\n",
       "      <td>1.644966e+07</td>\n",
       "      <td>1.616386e+07</td>\n",
       "      <td>-6.234288e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>3.594291e+07</td>\n",
       "      <td>3.594291e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0900</td>\n",
       "      <td>0.0900</td>\n",
       "      <td>0</td>\n",
       "      <td>3.594291e+07</td>\n",
       "      <td>3.594291e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>20111231</td>\n",
       "      <td>元</td>\n",
       "      <td>6.287400e+08</td>\n",
       "      <td>6.287400e+08</td>\n",
       "      <td>4.408832e+08</td>\n",
       "      <td>2.505863e+08</td>\n",
       "      <td>8.854633e+06</td>\n",
       "      <td>1.295373e+08</td>\n",
       "      <td>7.734728e+07</td>\n",
       "      <td>-3.310231e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.963836e+08</td>\n",
       "      <td>1.963836e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.4900</td>\n",
       "      <td>0.4900</td>\n",
       "      <td>0</td>\n",
       "      <td>1.963836e+08</td>\n",
       "      <td>1.963836e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>20110930</td>\n",
       "      <td>元</td>\n",
       "      <td>4.566521e+08</td>\n",
       "      <td>4.566521e+08</td>\n",
       "      <td>3.098315e+08</td>\n",
       "      <td>1.787144e+08</td>\n",
       "      <td>6.676691e+06</td>\n",
       "      <td>8.658443e+07</td>\n",
       "      <td>5.510714e+07</td>\n",
       "      <td>-2.516889e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.289811e+08</td>\n",
       "      <td>1.289811e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3200</td>\n",
       "      <td>0.3200</td>\n",
       "      <td>0</td>\n",
       "      <td>1.289811e+08</td>\n",
       "      <td>1.289811e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>20110630</td>\n",
       "      <td>元</td>\n",
       "      <td>3.124870e+08</td>\n",
       "      <td>3.124870e+08</td>\n",
       "      <td>2.012906e+08</td>\n",
       "      <td>1.131729e+08</td>\n",
       "      <td>5.127279e+06</td>\n",
       "      <td>5.440435e+07</td>\n",
       "      <td>3.559293e+07</td>\n",
       "      <td>-1.550309e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>9.758907e+07</td>\n",
       "      <td>9.758907e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2400</td>\n",
       "      <td>0.2400</td>\n",
       "      <td>0</td>\n",
       "      <td>9.758907e+07</td>\n",
       "      <td>9.758907e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>20110331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.287561e+08</td>\n",
       "      <td>1.287561e+08</td>\n",
       "      <td>9.348366e+07</td>\n",
       "      <td>4.817797e+07</td>\n",
       "      <td>1.883350e+06</td>\n",
       "      <td>3.081902e+07</td>\n",
       "      <td>1.815244e+07</td>\n",
       "      <td>-6.850567e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>3.021611e+07</td>\n",
       "      <td>3.021611e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0800</td>\n",
       "      <td>0.0800</td>\n",
       "      <td>0</td>\n",
       "      <td>3.021611e+07</td>\n",
       "      <td>3.021611e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>20101231</td>\n",
       "      <td>元</td>\n",
       "      <td>7.373136e+08</td>\n",
       "      <td>7.373136e+08</td>\n",
       "      <td>4.434078e+08</td>\n",
       "      <td>2.693060e+08</td>\n",
       "      <td>1.078073e+07</td>\n",
       "      <td>1.152408e+08</td>\n",
       "      <td>5.021841e+07</td>\n",
       "      <td>-5.342880e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>2.567881e+08</td>\n",
       "      <td>2.567881e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6900</td>\n",
       "      <td>0.6900</td>\n",
       "      <td>0</td>\n",
       "      <td>2.567881e+08</td>\n",
       "      <td>2.567881e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>20100930</td>\n",
       "      <td>元</td>\n",
       "      <td>4.723223e+08</td>\n",
       "      <td>4.723223e+08</td>\n",
       "      <td>2.756524e+08</td>\n",
       "      <td>1.629623e+08</td>\n",
       "      <td>7.566485e+06</td>\n",
       "      <td>7.280255e+07</td>\n",
       "      <td>3.214855e+07</td>\n",
       "      <td>-1.437665e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.731210e+08</td>\n",
       "      <td>1.731210e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.4800</td>\n",
       "      <td>0.4800</td>\n",
       "      <td>0</td>\n",
       "      <td>1.731210e+08</td>\n",
       "      <td>1.731210e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>20100630</td>\n",
       "      <td>元</td>\n",
       "      <td>3.308263e+08</td>\n",
       "      <td>3.308263e+08</td>\n",
       "      <td>1.781990e+08</td>\n",
       "      <td>1.024358e+08</td>\n",
       "      <td>5.507258e+06</td>\n",
       "      <td>4.802382e+07</td>\n",
       "      <td>2.181796e+07</td>\n",
       "      <td>-6.414912e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>1.311395e+08</td>\n",
       "      <td>1.311395e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3600</td>\n",
       "      <td>0.3600</td>\n",
       "      <td>0</td>\n",
       "      <td>1.311395e+08</td>\n",
       "      <td>1.311395e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>20100331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.063393e+08</td>\n",
       "      <td>1.063393e+08</td>\n",
       "      <td>7.863087e+07</td>\n",
       "      <td>4.370640e+07</td>\n",
       "      <td>1.796246e+06</td>\n",
       "      <td>2.168920e+07</td>\n",
       "      <td>1.042695e+07</td>\n",
       "      <td>-9.572709e+04</td>\n",
       "      <td>...</td>\n",
       "      <td>2.369565e+07</td>\n",
       "      <td>2.369565e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>0</td>\n",
       "      <td>2.369565e+07</td>\n",
       "      <td>2.369565e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>20091231</td>\n",
       "      <td>元</td>\n",
       "      <td>6.040475e+08</td>\n",
       "      <td>6.040475e+08</td>\n",
       "      <td>3.465344e+08</td>\n",
       "      <td>1.885044e+08</td>\n",
       "      <td>9.912864e+06</td>\n",
       "      <td>1.058044e+08</td>\n",
       "      <td>4.203399e+07</td>\n",
       "      <td>-3.599439e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>2.315897e+08</td>\n",
       "      <td>2.315897e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6400</td>\n",
       "      <td>0.6400</td>\n",
       "      <td>0</td>\n",
       "      <td>2.315897e+08</td>\n",
       "      <td>2.315897e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>20090930</td>\n",
       "      <td>元</td>\n",
       "      <td>4.184630e+08</td>\n",
       "      <td>4.184630e+08</td>\n",
       "      <td>2.456036e+08</td>\n",
       "      <td>1.340287e+08</td>\n",
       "      <td>7.258599e+06</td>\n",
       "      <td>7.215039e+07</td>\n",
       "      <td>3.161526e+07</td>\n",
       "      <td>-1.088891e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>1.535120e+08</td>\n",
       "      <td>1.535120e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.4300</td>\n",
       "      <td>0.4300</td>\n",
       "      <td>0</td>\n",
       "      <td>1.535120e+08</td>\n",
       "      <td>1.535120e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>20081231</td>\n",
       "      <td>元</td>\n",
       "      <td>5.903357e+08</td>\n",
       "      <td>5.903357e+08</td>\n",
       "      <td>3.689559e+08</td>\n",
       "      <td>2.148530e+08</td>\n",
       "      <td>9.395463e+06</td>\n",
       "      <td>1.089430e+08</td>\n",
       "      <td>3.123171e+07</td>\n",
       "      <td>7.728633e+04</td>\n",
       "      <td>...</td>\n",
       "      <td>1.900513e+08</td>\n",
       "      <td>1.900513e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5300</td>\n",
       "      <td>0.5300</td>\n",
       "      <td>0</td>\n",
       "      <td>1.900513e+08</td>\n",
       "      <td>1.900513e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>20071231</td>\n",
       "      <td>元</td>\n",
       "      <td>4.924289e+08</td>\n",
       "      <td>4.924289e+08</td>\n",
       "      <td>3.124258e+08</td>\n",
       "      <td>2.073765e+08</td>\n",
       "      <td>7.231585e+06</td>\n",
       "      <td>8.375439e+07</td>\n",
       "      <td>1.406509e+07</td>\n",
       "      <td>-2.556585e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>1.520091e+08</td>\n",
       "      <td>1.520091e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.4200</td>\n",
       "      <td>0.4200</td>\n",
       "      <td>0</td>\n",
       "      <td>1.520091e+08</td>\n",
       "      <td>1.520091e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>19700101</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>57 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        报表日期   单位       一、营业总收入          营业收入       二、营业总成本          营业成本  \\\n",
       "0   20221231    元  3.826401e+10  3.826401e+10  2.904984e+10  2.539550e+10   \n",
       "1   20220930    元  2.782329e+10  2.782329e+10  2.107379e+10  1.858638e+10   \n",
       "2   20220630    元  1.835375e+10  1.835375e+10  1.381560e+10  1.221367e+10   \n",
       "3   20220331    元  8.841150e+09  8.841150e+09  6.503327e+09  5.864038e+09   \n",
       "4   20211231    元  3.065242e+10  3.065242e+10  1.846648e+10  1.562180e+10   \n",
       "5   20210930    元  2.182866e+10  2.182866e+10  1.182180e+10  1.003811e+10   \n",
       "6   20210630    元  1.317148e+10  1.317148e+10  6.662966e+09  5.491862e+09   \n",
       "7   20210331    元  3.926601e+09  3.926601e+09  2.756079e+09  2.318670e+09   \n",
       "8   20201231    元  1.519037e+10  1.519037e+10  1.117980e+10  9.268009e+09   \n",
       "9   20200930    元  1.104979e+10  1.104979e+10  7.969426e+09  6.627694e+09   \n",
       "10  20200630    元  6.993723e+09  6.993723e+09  5.036619e+09  4.303097e+09   \n",
       "11  20200331    元  2.634599e+09  2.634599e+09  1.939468e+09  1.657523e+09   \n",
       "12  20191231    元  1.058732e+10  1.058732e+10  7.709980e+09  6.135815e+09   \n",
       "13  20190930    元  7.666171e+09  7.666171e+09  5.475325e+09  4.450911e+09   \n",
       "14  20190630    元  5.038678e+09  5.038678e+09  3.600468e+09  2.964282e+09   \n",
       "15  20190331    元  2.293537e+09  2.293537e+09  1.673250e+09  1.378965e+09   \n",
       "16  20181231    元  5.228308e+09  5.228308e+09  3.527055e+09  2.364930e+09   \n",
       "17  20180930    元  3.494879e+09  3.494879e+09  2.210957e+09  1.507394e+09   \n",
       "18  20180630    元  2.071876e+09  2.071876e+09  1.270661e+09  8.453442e+08   \n",
       "19  20180331    元  8.383283e+08  8.383283e+08  5.301718e+08  3.775706e+08   \n",
       "20  20171231    元  1.342569e+09  1.342569e+09  8.372390e+08  2.880615e+08   \n",
       "21  20170930    元  7.690548e+08  7.690548e+08  4.441503e+08  9.245599e+07   \n",
       "22  20170630    元  4.451620e+08  4.451620e+08  2.489089e+08  3.444997e+07   \n",
       "23  20170331    元  1.622370e+08  1.622370e+08  9.485878e+07  1.002407e+07   \n",
       "24  20161231    元  4.459472e+08  4.459472e+08  4.163816e+08  3.521882e+07   \n",
       "25  20160930    元  2.732335e+08  2.732335e+08  2.724444e+08  1.987151e+07   \n",
       "26  20160630    元  1.839440e+08  1.839440e+08  1.748111e+08  1.653117e+07   \n",
       "27  20160331    元  1.437181e+08  1.437181e+08  7.716280e+07  9.824917e+06   \n",
       "28  20151231    元  7.127381e+08  7.127381e+08  4.943913e+08  1.417646e+08   \n",
       "29  20150930    元  5.552421e+08  5.552421e+08  3.745873e+08  1.295146e+08   \n",
       "30  20150630    元  3.846178e+08  3.846178e+08  2.605976e+08  1.122350e+08   \n",
       "31  20150331    元  1.964726e+08  1.964726e+08  1.430482e+08  7.867512e+07   \n",
       "32  20141231    元  8.009375e+08  8.009375e+08  6.283652e+08  3.107933e+08   \n",
       "33  20140930    元  5.772012e+08  5.772012e+08  4.181663e+08  2.223132e+08   \n",
       "34  20140630    元  3.804983e+08  3.804983e+08  2.685228e+08  1.460294e+08   \n",
       "35  20140331    元  1.626753e+08  1.626753e+08  1.130584e+08  6.820405e+07   \n",
       "36  20131231    元  7.801779e+08  7.801779e+08  6.337309e+08  3.080549e+08   \n",
       "37  20130930    元  5.802861e+08  5.802861e+08  4.317369e+08  2.471864e+08   \n",
       "38  20130630    元  4.255763e+08  4.255763e+08  3.088316e+08  1.883981e+08   \n",
       "39  20130331    元  1.845495e+08  1.845495e+08  1.380217e+08  9.368991e+07   \n",
       "40  20121231    元  7.646197e+08  7.646197e+08  5.491002e+08  3.382518e+08   \n",
       "41  20120930    元  4.969606e+08  4.969606e+08  3.682727e+08  2.245410e+08   \n",
       "42  20120630    元  3.279894e+08  3.279894e+08  2.379716e+08  1.554276e+08   \n",
       "43  20120331    元  1.385710e+08  1.385710e+08  9.805952e+07  6.784050e+07   \n",
       "44  20111231    元  6.287400e+08  6.287400e+08  4.408832e+08  2.505863e+08   \n",
       "45  20110930    元  4.566521e+08  4.566521e+08  3.098315e+08  1.787144e+08   \n",
       "46  20110630    元  3.124870e+08  3.124870e+08  2.012906e+08  1.131729e+08   \n",
       "47  20110331    元  1.287561e+08  1.287561e+08  9.348366e+07  4.817797e+07   \n",
       "48  20101231    元  7.373136e+08  7.373136e+08  4.434078e+08  2.693060e+08   \n",
       "49  20100930    元  4.723223e+08  4.723223e+08  2.756524e+08  1.629623e+08   \n",
       "50  20100630    元  3.308263e+08  3.308263e+08  1.781990e+08  1.024358e+08   \n",
       "51  20100331    元  1.063393e+08  1.063393e+08  7.863087e+07  4.370640e+07   \n",
       "52  20091231    元  6.040475e+08  6.040475e+08  3.465344e+08  1.885044e+08   \n",
       "53  20090930    元  4.184630e+08  4.184630e+08  2.456036e+08  1.340287e+08   \n",
       "54  20081231    元  5.903357e+08  5.903357e+08  3.689559e+08  2.148530e+08   \n",
       "55  20071231    元  4.924289e+08  4.924289e+08  3.124258e+08  2.073765e+08   \n",
       "56  19700101  NaN  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "\n",
       "         营业税金及附加          销售费用          管理费用          财务费用  ...         五、净利润  \\\n",
       "0   1.770219e+08  2.235237e+09  3.741262e+08  1.379832e+07  ...  7.539000e+09   \n",
       "1   1.273912e+08  1.469335e+09  2.758392e+08  7.344287e+06  ...  5.607155e+09   \n",
       "2   8.491797e+07  9.506678e+08  1.716994e+08  6.921587e+06  ...  3.729017e+09   \n",
       "3   3.662546e+07  3.626753e+08  7.206652e+07  7.030685e+06  ...  1.922757e+09   \n",
       "4   1.352342e+08  1.834807e+09  3.001955e+08  2.182127e+07  ...  1.020855e+10   \n",
       "5   9.743332e+07  1.225365e+09  2.008999e+08  1.965119e+07  ...  8.403608e+09   \n",
       "6   6.201584e+07  7.781028e+08  1.290693e+08  3.918659e+07  ...  5.490650e+09   \n",
       "7   1.638660e+07  2.719420e+08  5.710977e+07  3.035498e+07  ...  9.381791e+08   \n",
       "8   7.098972e+07  1.197507e+09  2.122592e+08  1.313844e+08  ...  3.301327e+09   \n",
       "9   4.983327e+07  8.189057e+08  1.415956e+08  1.104116e+08  ...  2.478596e+09   \n",
       "10  3.269298e+07  4.294139e+08  9.254171e+07  7.282094e+07  ...  1.504548e+09   \n",
       "11  1.127358e+07  1.366930e+08  4.782170e+07  3.870799e+07  ...  5.163634e+08   \n",
       "12  5.141446e+07  1.095580e+09  1.826917e+08  7.492645e+07  ...  2.366439e+09   \n",
       "13  3.538434e+07  7.086295e+08  1.262015e+08  4.967168e+07  ...  1.762941e+09   \n",
       "14  2.447402e+07  4.394425e+08  7.973578e+07  2.514876e+07  ...  1.146970e+09   \n",
       "15  9.417647e+06  1.640910e+08  4.015490e+07  1.023333e+07  ...  5.020661e+08   \n",
       "16  2.838358e+07  7.653167e+08  1.335025e+08  1.816713e+07  ...  1.451367e+09   \n",
       "17  1.769687e+07  4.721613e+08  1.839704e+08  6.834894e+06  ...  1.086588e+09   \n",
       "18  1.191289e+07  2.941416e+08  1.045435e+08  1.777847e+06  ...  6.823785e+08   \n",
       "19  3.446958e+06  8.700206e+07  5.381581e+07  3.132290e+05  ...  2.596324e+08   \n",
       "20  1.219603e+07  3.143401e+08  1.873274e+08 -1.209225e+07  ...  4.322754e+08   \n",
       "21  6.689791e+06  1.885112e+08  1.267347e+08 -6.744314e+06  ...  2.852348e+08   \n",
       "22  5.166075e+06  1.069302e+08  7.909058e+07 -6.392373e+06  ...  1.717901e+08   \n",
       "23  6.873437e+05  3.454272e+07  3.897243e+07 -2.811938e+06  ...  6.031745e+07   \n",
       "24  5.538279e+06  2.016168e+08  1.543616e+08 -1.845406e+07  ...  3.252031e+07   \n",
       "25  1.156749e+06  1.287736e+08  1.051396e+08 -1.401248e+07  ...  6.761262e+06   \n",
       "26  6.061102e+05  7.744687e+07  6.725415e+07 -9.199014e+06  ...  1.203886e+07   \n",
       "27  5.782926e+05  2.779000e+07  3.405929e+07 -4.364309e+06  ...  5.919843e+07   \n",
       "28  4.710302e+06  2.391420e+08  1.258705e+08 -2.759567e+07  ...  1.974019e+08   \n",
       "29  3.145295e+06  1.598761e+08  8.937196e+07 -2.026475e+07  ...  1.604950e+08   \n",
       "30  2.376026e+06  9.427485e+07  5.650317e+07 -1.266529e+07  ...  1.081221e+08   \n",
       "31  1.049326e+06  3.730860e+07  2.787392e+07 -6.311175e+06  ...  4.770840e+07   \n",
       "32  7.097341e+06  2.106387e+08  1.115840e+08 -2.458272e+07  ...  1.480040e+08   \n",
       "33  4.984528e+06  1.206588e+08  7.484325e+07 -1.842650e+07  ...  1.369069e+08   \n",
       "34  3.646606e+06  6.970584e+07  4.988302e+07 -1.338157e+07  ...  9.587459e+07   \n",
       "35  1.359633e+06  1.997322e+07  2.598349e+07 -6.084446e+06  ...  4.259445e+07   \n",
       "36  8.305535e+06  1.489785e+08  1.523629e+08 -2.501208e+07  ...  1.303478e+08   \n",
       "37  5.599594e+06  9.909023e+07  8.863074e+07 -1.855409e+07  ...  1.315284e+08   \n",
       "38  4.172664e+06  5.953447e+07  6.397482e+07 -1.510489e+07  ...  1.022422e+08   \n",
       "39  1.639516e+06  2.354024e+07  2.209933e+07 -5.888346e+06  ...  4.130339e+07   \n",
       "40  7.152259e+06  1.488400e+08  8.465827e+07 -3.124095e+07  ...  2.179439e+08   \n",
       "41  4.730511e+06  1.020268e+08  5.560137e+07 -2.383421e+07  ...  1.437329e+08   \n",
       "42  3.504702e+06  5.362713e+07  3.534834e+07 -1.344091e+07  ...  1.085375e+08   \n",
       "43  9.815469e+05  1.644966e+07  1.616386e+07 -6.234288e+06  ...  3.594291e+07   \n",
       "44  8.854633e+06  1.295373e+08  7.734728e+07 -3.310231e+07  ...  1.963836e+08   \n",
       "45  6.676691e+06  8.658443e+07  5.510714e+07 -2.516889e+07  ...  1.289811e+08   \n",
       "46  5.127279e+06  5.440435e+07  3.559293e+07 -1.550309e+07  ...  9.758907e+07   \n",
       "47  1.883350e+06  3.081902e+07  1.815244e+07 -6.850567e+06  ...  3.021611e+07   \n",
       "48  1.078073e+07  1.152408e+08  5.021841e+07 -5.342880e+06  ...  2.567881e+08   \n",
       "49  7.566485e+06  7.280255e+07  3.214855e+07 -1.437665e+06  ...  1.731210e+08   \n",
       "50  5.507258e+06  4.802382e+07  2.181796e+07 -6.414912e+05  ...  1.311395e+08   \n",
       "51  1.796246e+06  2.168920e+07  1.042695e+07 -9.572709e+04  ...  2.369565e+07   \n",
       "52  9.912864e+06  1.058044e+08  4.203399e+07 -3.599439e+05  ...  2.315897e+08   \n",
       "53  7.258599e+06  7.215039e+07  3.161526e+07 -1.088891e+05  ...  1.535120e+08   \n",
       "54  9.395463e+06  1.089430e+08  3.123171e+07  7.728633e+04  ...  1.900513e+08   \n",
       "55  7.231585e+06  8.375439e+07  1.406509e+07 -2.556585e+05  ...  1.520091e+08   \n",
       "56  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00  ...  0.000000e+00   \n",
       "\n",
       "    归属于母公司所有者的净利润  少数股东损益  六、每股收益  基本每股收益(元/股)  稀释每股收益(元/股)  七、其他综合收益  \\\n",
       "0    7.539000e+09       0     NaN       4.7119       4.7119         0   \n",
       "1    5.607155e+09       0     NaN       3.5045       3.5045         0   \n",
       "2    3.729017e+09       0     NaN       2.3306       2.3306         0   \n",
       "3    1.922757e+09       0     NaN       1.2017       1.2017         0   \n",
       "4    1.020855e+10       0     NaN       6.3803       6.3803         0   \n",
       "5    8.403608e+09       0     NaN       5.2523       5.2523         0   \n",
       "6    5.490650e+09       0     NaN       3.4317       3.4317         0   \n",
       "7    9.381791e+08       0     NaN       0.5864       0.5864         0   \n",
       "8    3.301327e+09       0     NaN       2.0633       2.0633         0   \n",
       "9    2.478596e+09       0     NaN       1.5491       1.5491         0   \n",
       "10   1.504548e+09       0     NaN       0.9403       0.9403         0   \n",
       "11   5.163634e+08       0     NaN       0.3227       0.3227         0   \n",
       "12   2.366439e+09       0     NaN       1.4790       1.4790         0   \n",
       "13   1.762941e+09       0     NaN       1.1018       1.1018         0   \n",
       "14   1.146970e+09       0     NaN       0.7169       0.7169         0   \n",
       "15   5.020661e+08       0     NaN       0.3138       0.3138         0   \n",
       "16   1.451367e+09       0     NaN       0.9071       0.9071         0   \n",
       "17   1.086588e+09       0     NaN       0.6791       0.6791         0   \n",
       "18   6.823785e+08       0     NaN       0.4265       0.4265         0   \n",
       "19   2.596324e+08       0     NaN       0.1623       0.1623         0   \n",
       "20   4.322754e+08       0     NaN       0.2700       0.2700         0   \n",
       "21   2.852348e+08       0     NaN       0.1783       0.1783         0   \n",
       "22   1.717901e+08       0     NaN       0.1100       0.1100         0   \n",
       "23   6.031745e+07       0     NaN       0.0400       0.0400         0   \n",
       "24   3.252031e+07       0     NaN       0.0200       0.0200         0   \n",
       "25   6.761262e+06       0     NaN       0.0042       0.0042         0   \n",
       "26   1.203886e+07       0     NaN       0.0100       0.0100         0   \n",
       "27   5.919843e+07       0     NaN       0.0700       0.0700         0   \n",
       "28   1.974019e+08       0     NaN       0.2500       0.2500         0   \n",
       "29   1.604950e+08       0     NaN       0.2000       0.2000         0   \n",
       "30   1.081221e+08       0     NaN       0.1400       0.1400         0   \n",
       "31   4.770840e+07       0     NaN       0.0600       0.0600         0   \n",
       "32   1.480040e+08       0     NaN       0.1900       0.1900         0   \n",
       "33   1.369069e+08       0     NaN       0.1700       0.1700         0   \n",
       "34   9.587459e+07       0     NaN       0.1200       0.1200         0   \n",
       "35   4.259445e+07       0     NaN       0.1100       0.1100         0   \n",
       "36   1.303478e+08       0     NaN       0.3300       0.3300         0   \n",
       "37   1.315284e+08       0     NaN       0.3300       0.3300         0   \n",
       "38   1.022422e+08       0     NaN       0.2600       0.2600         0   \n",
       "39   4.130339e+07       0     NaN       0.1000       0.1000         0   \n",
       "40   2.179439e+08       0     NaN       0.5400       0.5400         0   \n",
       "41   1.437329e+08       0     NaN       0.3600       0.3600         0   \n",
       "42   1.085375e+08       0     NaN       0.2700       0.2700         0   \n",
       "43   3.594291e+07       0     NaN       0.0900       0.0900         0   \n",
       "44   1.963836e+08       0     NaN       0.4900       0.4900         0   \n",
       "45   1.289811e+08       0     NaN       0.3200       0.3200         0   \n",
       "46   9.758907e+07       0     NaN       0.2400       0.2400         0   \n",
       "47   3.021611e+07       0     NaN       0.0800       0.0800         0   \n",
       "48   2.567881e+08       0     NaN       0.6900       0.6900         0   \n",
       "49   1.731210e+08       0     NaN       0.4800       0.4800         0   \n",
       "50   1.311395e+08       0     NaN       0.3600       0.3600         0   \n",
       "51   2.369565e+07       0     NaN       0.0700       0.0700         0   \n",
       "52   2.315897e+08       0     NaN       0.6400       0.6400         0   \n",
       "53   1.535120e+08       0     NaN       0.4300       0.4300         0   \n",
       "54   1.900513e+08       0     NaN       0.5300       0.5300         0   \n",
       "55   1.520091e+08       0     NaN       0.4200       0.4200         0   \n",
       "56   0.000000e+00       0     NaN       0.0000       0.0000         0   \n",
       "\n",
       "        八、综合收益总额  归属于母公司所有者的综合收益总额  归属于少数股东的综合收益总额  \n",
       "0   7.539000e+09      7.539000e+09               0  \n",
       "1   5.607155e+09      5.607155e+09               0  \n",
       "2   3.729017e+09      3.729017e+09               0  \n",
       "3   1.922757e+09      1.922757e+09               0  \n",
       "4   1.020855e+10      1.020855e+10               0  \n",
       "5   8.403608e+09      8.403608e+09               0  \n",
       "6   5.490650e+09      5.490650e+09               0  \n",
       "7   9.381791e+08      9.381791e+08               0  \n",
       "8   3.301327e+09      3.301327e+09               0  \n",
       "9   2.478596e+09      2.478596e+09               0  \n",
       "10  1.504548e+09      1.504548e+09               0  \n",
       "11  5.163634e+08      5.163634e+08               0  \n",
       "12  2.366439e+09      2.366439e+09               0  \n",
       "13  1.762941e+09      1.762941e+09               0  \n",
       "14  1.146970e+09      1.146970e+09               0  \n",
       "15  5.020661e+08      5.020661e+08               0  \n",
       "16  1.451367e+09      1.451367e+09               0  \n",
       "17  1.086588e+09      1.086588e+09               0  \n",
       "18  6.823785e+08      6.823785e+08               0  \n",
       "19  2.596324e+08      2.596324e+08               0  \n",
       "20  4.322754e+08      4.322754e+08               0  \n",
       "21  2.852348e+08      2.852348e+08               0  \n",
       "22  1.717901e+08      1.717901e+08               0  \n",
       "23  6.031745e+07      6.031745e+07               0  \n",
       "24  3.252031e+07      3.252031e+07               0  \n",
       "25  6.761262e+06      6.761262e+06               0  \n",
       "26  1.203886e+07      1.203886e+07               0  \n",
       "27  5.919843e+07      5.919843e+07               0  \n",
       "28  1.974019e+08      1.974019e+08               0  \n",
       "29  1.604950e+08      1.604950e+08               0  \n",
       "30  1.081221e+08      1.081221e+08               0  \n",
       "31  4.770840e+07      4.770840e+07               0  \n",
       "32  1.480040e+08      1.480040e+08               0  \n",
       "33  1.369069e+08      1.369069e+08               0  \n",
       "34  9.587459e+07      9.587459e+07               0  \n",
       "35  4.259445e+07      4.259445e+07               0  \n",
       "36  1.303478e+08      1.303478e+08               0  \n",
       "37  1.315284e+08      1.315284e+08               0  \n",
       "38  1.022422e+08      1.022422e+08               0  \n",
       "39  4.130339e+07      4.130339e+07               0  \n",
       "40  2.179439e+08      2.179439e+08               0  \n",
       "41  1.437329e+08      1.437329e+08               0  \n",
       "42  1.085375e+08      1.085375e+08               0  \n",
       "43  3.594291e+07      3.594291e+07               0  \n",
       "44  1.963836e+08      1.963836e+08               0  \n",
       "45  1.289811e+08      1.289811e+08               0  \n",
       "46  9.758907e+07      9.758907e+07               0  \n",
       "47  3.021611e+07      3.021611e+07               0  \n",
       "48  2.567881e+08      2.567881e+08               0  \n",
       "49  1.731210e+08      1.731210e+08               0  \n",
       "50  1.311395e+08      1.311395e+08               0  \n",
       "51  2.369565e+07      2.369565e+07               0  \n",
       "52  2.315897e+08      2.315897e+08               0  \n",
       "53  1.535120e+08      1.535120e+08               0  \n",
       "54  1.900513e+08      1.900513e+08               0  \n",
       "55  1.520091e+08      1.520091e+08               0  \n",
       "56  0.000000e+00      0.000000e+00               0  \n",
       "\n",
       "[57 rows x 32 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.loc[data.isnull().any(axis=1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "46ec8597",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "报表日期                   0\n",
       "单位                     1\n",
       "一、营业总收入                0\n",
       "营业收入                   0\n",
       "二、营业总成本                0\n",
       "营业成本                   0\n",
       "营业税金及附加                0\n",
       "销售费用                   0\n",
       "管理费用                   0\n",
       "财务费用                   0\n",
       "研发费用                   0\n",
       "资产减值损失                 0\n",
       "公允价值变动收益               0\n",
       "投资收益                   0\n",
       "其中:对联营企业和合营企业的投资收益     0\n",
       "汇兑收益                   0\n",
       "三、营业利润                 0\n",
       "加:营业外收入                0\n",
       "减：营业外支出                0\n",
       "其中：非流动资产处置损失           0\n",
       "四、利润总额                 0\n",
       "减：所得税费用                0\n",
       "五、净利润                  0\n",
       "归属于母公司所有者的净利润          0\n",
       "少数股东损益                 0\n",
       "六、每股收益                57\n",
       "基本每股收益(元/股)            0\n",
       "稀释每股收益(元/股)            0\n",
       "七、其他综合收益               0\n",
       "八、综合收益总额               0\n",
       "归属于母公司所有者的综合收益总额       0\n",
       "归属于少数股东的综合收益总额         0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum(axis=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "1a683265",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>报表日期</th>\n",
       "      <th>单位</th>\n",
       "      <th>一、营业总收入</th>\n",
       "      <th>营业收入</th>\n",
       "      <th>二、营业总成本</th>\n",
       "      <th>营业成本</th>\n",
       "      <th>营业税金及附加</th>\n",
       "      <th>销售费用</th>\n",
       "      <th>管理费用</th>\n",
       "      <th>财务费用</th>\n",
       "      <th>...</th>\n",
       "      <th>五、净利润</th>\n",
       "      <th>归属于母公司所有者的净利润</th>\n",
       "      <th>少数股东损益</th>\n",
       "      <th>六、每股收益</th>\n",
       "      <th>基本每股收益(元/股)</th>\n",
       "      <th>稀释每股收益(元/股)</th>\n",
       "      <th>七、其他综合收益</th>\n",
       "      <th>八、综合收益总额</th>\n",
       "      <th>归属于母公司所有者的综合收益总额</th>\n",
       "      <th>归属于少数股东的综合收益总额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20221231</td>\n",
       "      <td>元</td>\n",
       "      <td>3.826401e+10</td>\n",
       "      <td>3.826401e+10</td>\n",
       "      <td>2.904984e+10</td>\n",
       "      <td>2.539550e+10</td>\n",
       "      <td>1.770219e+08</td>\n",
       "      <td>2.235237e+09</td>\n",
       "      <td>3.741262e+08</td>\n",
       "      <td>1.379832e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>7.539000e+09</td>\n",
       "      <td>7.539000e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.7119</td>\n",
       "      <td>4.7119</td>\n",
       "      <td>0</td>\n",
       "      <td>7.539000e+09</td>\n",
       "      <td>7.539000e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20220930</td>\n",
       "      <td>元</td>\n",
       "      <td>2.782329e+10</td>\n",
       "      <td>2.782329e+10</td>\n",
       "      <td>2.107379e+10</td>\n",
       "      <td>1.858638e+10</td>\n",
       "      <td>1.273912e+08</td>\n",
       "      <td>1.469335e+09</td>\n",
       "      <td>2.758392e+08</td>\n",
       "      <td>7.344287e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>5.607155e+09</td>\n",
       "      <td>5.607155e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.5045</td>\n",
       "      <td>3.5045</td>\n",
       "      <td>0</td>\n",
       "      <td>5.607155e+09</td>\n",
       "      <td>5.607155e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20220630</td>\n",
       "      <td>元</td>\n",
       "      <td>1.835375e+10</td>\n",
       "      <td>1.835375e+10</td>\n",
       "      <td>1.381560e+10</td>\n",
       "      <td>1.221367e+10</td>\n",
       "      <td>8.491797e+07</td>\n",
       "      <td>9.506678e+08</td>\n",
       "      <td>1.716994e+08</td>\n",
       "      <td>6.921587e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>3.729017e+09</td>\n",
       "      <td>3.729017e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.3306</td>\n",
       "      <td>2.3306</td>\n",
       "      <td>0</td>\n",
       "      <td>3.729017e+09</td>\n",
       "      <td>3.729017e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20220331</td>\n",
       "      <td>元</td>\n",
       "      <td>8.841150e+09</td>\n",
       "      <td>8.841150e+09</td>\n",
       "      <td>6.503327e+09</td>\n",
       "      <td>5.864038e+09</td>\n",
       "      <td>3.662546e+07</td>\n",
       "      <td>3.626753e+08</td>\n",
       "      <td>7.206652e+07</td>\n",
       "      <td>7.030685e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.922757e+09</td>\n",
       "      <td>1.922757e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2017</td>\n",
       "      <td>1.2017</td>\n",
       "      <td>0</td>\n",
       "      <td>1.922757e+09</td>\n",
       "      <td>1.922757e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20211231</td>\n",
       "      <td>元</td>\n",
       "      <td>3.065242e+10</td>\n",
       "      <td>3.065242e+10</td>\n",
       "      <td>1.846648e+10</td>\n",
       "      <td>1.562180e+10</td>\n",
       "      <td>1.352342e+08</td>\n",
       "      <td>1.834807e+09</td>\n",
       "      <td>3.001955e+08</td>\n",
       "      <td>2.182127e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.3803</td>\n",
       "      <td>6.3803</td>\n",
       "      <td>0</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>1.020855e+10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>20210930</td>\n",
       "      <td>元</td>\n",
       "      <td>2.182866e+10</td>\n",
       "      <td>2.182866e+10</td>\n",
       "      <td>1.182180e+10</td>\n",
       "      <td>1.003811e+10</td>\n",
       "      <td>9.743332e+07</td>\n",
       "      <td>1.225365e+09</td>\n",
       "      <td>2.008999e+08</td>\n",
       "      <td>1.965119e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>8.403608e+09</td>\n",
       "      <td>8.403608e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.2523</td>\n",
       "      <td>5.2523</td>\n",
       "      <td>0</td>\n",
       "      <td>8.403608e+09</td>\n",
       "      <td>8.403608e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>20210630</td>\n",
       "      <td>元</td>\n",
       "      <td>1.317148e+10</td>\n",
       "      <td>1.317148e+10</td>\n",
       "      <td>6.662966e+09</td>\n",
       "      <td>5.491862e+09</td>\n",
       "      <td>6.201584e+07</td>\n",
       "      <td>7.781028e+08</td>\n",
       "      <td>1.290693e+08</td>\n",
       "      <td>3.918659e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>5.490650e+09</td>\n",
       "      <td>5.490650e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4317</td>\n",
       "      <td>3.4317</td>\n",
       "      <td>0</td>\n",
       "      <td>5.490650e+09</td>\n",
       "      <td>5.490650e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>20210331</td>\n",
       "      <td>元</td>\n",
       "      <td>3.926601e+09</td>\n",
       "      <td>3.926601e+09</td>\n",
       "      <td>2.756079e+09</td>\n",
       "      <td>2.318670e+09</td>\n",
       "      <td>1.638660e+07</td>\n",
       "      <td>2.719420e+08</td>\n",
       "      <td>5.710977e+07</td>\n",
       "      <td>3.035498e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>9.381791e+08</td>\n",
       "      <td>9.381791e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5864</td>\n",
       "      <td>0.5864</td>\n",
       "      <td>0</td>\n",
       "      <td>9.381791e+08</td>\n",
       "      <td>9.381791e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>20201231</td>\n",
       "      <td>元</td>\n",
       "      <td>1.519037e+10</td>\n",
       "      <td>1.519037e+10</td>\n",
       "      <td>1.117980e+10</td>\n",
       "      <td>9.268009e+09</td>\n",
       "      <td>7.098972e+07</td>\n",
       "      <td>1.197507e+09</td>\n",
       "      <td>2.122592e+08</td>\n",
       "      <td>1.313844e+08</td>\n",
       "      <td>...</td>\n",
       "      <td>3.301327e+09</td>\n",
       "      <td>3.301327e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0633</td>\n",
       "      <td>2.0633</td>\n",
       "      <td>0</td>\n",
       "      <td>3.301327e+09</td>\n",
       "      <td>3.301327e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>20200930</td>\n",
       "      <td>元</td>\n",
       "      <td>1.104979e+10</td>\n",
       "      <td>1.104979e+10</td>\n",
       "      <td>7.969426e+09</td>\n",
       "      <td>6.627694e+09</td>\n",
       "      <td>4.983327e+07</td>\n",
       "      <td>8.189057e+08</td>\n",
       "      <td>1.415956e+08</td>\n",
       "      <td>1.104116e+08</td>\n",
       "      <td>...</td>\n",
       "      <td>2.478596e+09</td>\n",
       "      <td>2.478596e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.5491</td>\n",
       "      <td>1.5491</td>\n",
       "      <td>0</td>\n",
       "      <td>2.478596e+09</td>\n",
       "      <td>2.478596e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>20200630</td>\n",
       "      <td>元</td>\n",
       "      <td>6.993723e+09</td>\n",
       "      <td>6.993723e+09</td>\n",
       "      <td>5.036619e+09</td>\n",
       "      <td>4.303097e+09</td>\n",
       "      <td>3.269298e+07</td>\n",
       "      <td>4.294139e+08</td>\n",
       "      <td>9.254171e+07</td>\n",
       "      <td>7.282094e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.504548e+09</td>\n",
       "      <td>1.504548e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.9403</td>\n",
       "      <td>0.9403</td>\n",
       "      <td>0</td>\n",
       "      <td>1.504548e+09</td>\n",
       "      <td>1.504548e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>20200331</td>\n",
       "      <td>元</td>\n",
       "      <td>2.634599e+09</td>\n",
       "      <td>2.634599e+09</td>\n",
       "      <td>1.939468e+09</td>\n",
       "      <td>1.657523e+09</td>\n",
       "      <td>1.127358e+07</td>\n",
       "      <td>1.366930e+08</td>\n",
       "      <td>4.782170e+07</td>\n",
       "      <td>3.870799e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>5.163634e+08</td>\n",
       "      <td>5.163634e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3227</td>\n",
       "      <td>0.3227</td>\n",
       "      <td>0</td>\n",
       "      <td>5.163634e+08</td>\n",
       "      <td>5.163634e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>20191231</td>\n",
       "      <td>元</td>\n",
       "      <td>1.058732e+10</td>\n",
       "      <td>1.058732e+10</td>\n",
       "      <td>7.709980e+09</td>\n",
       "      <td>6.135815e+09</td>\n",
       "      <td>5.141446e+07</td>\n",
       "      <td>1.095580e+09</td>\n",
       "      <td>1.826917e+08</td>\n",
       "      <td>7.492645e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>2.366439e+09</td>\n",
       "      <td>2.366439e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.4790</td>\n",
       "      <td>1.4790</td>\n",
       "      <td>0</td>\n",
       "      <td>2.366439e+09</td>\n",
       "      <td>2.366439e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>20190930</td>\n",
       "      <td>元</td>\n",
       "      <td>7.666171e+09</td>\n",
       "      <td>7.666171e+09</td>\n",
       "      <td>5.475325e+09</td>\n",
       "      <td>4.450911e+09</td>\n",
       "      <td>3.538434e+07</td>\n",
       "      <td>7.086295e+08</td>\n",
       "      <td>1.262015e+08</td>\n",
       "      <td>4.967168e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.762941e+09</td>\n",
       "      <td>1.762941e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.1018</td>\n",
       "      <td>1.1018</td>\n",
       "      <td>0</td>\n",
       "      <td>1.762941e+09</td>\n",
       "      <td>1.762941e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>20190630</td>\n",
       "      <td>元</td>\n",
       "      <td>5.038678e+09</td>\n",
       "      <td>5.038678e+09</td>\n",
       "      <td>3.600468e+09</td>\n",
       "      <td>2.964282e+09</td>\n",
       "      <td>2.447402e+07</td>\n",
       "      <td>4.394425e+08</td>\n",
       "      <td>7.973578e+07</td>\n",
       "      <td>2.514876e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.146970e+09</td>\n",
       "      <td>1.146970e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.7169</td>\n",
       "      <td>0.7169</td>\n",
       "      <td>0</td>\n",
       "      <td>1.146970e+09</td>\n",
       "      <td>1.146970e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>20190331</td>\n",
       "      <td>元</td>\n",
       "      <td>2.293537e+09</td>\n",
       "      <td>2.293537e+09</td>\n",
       "      <td>1.673250e+09</td>\n",
       "      <td>1.378965e+09</td>\n",
       "      <td>9.417647e+06</td>\n",
       "      <td>1.640910e+08</td>\n",
       "      <td>4.015490e+07</td>\n",
       "      <td>1.023333e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>5.020661e+08</td>\n",
       "      <td>5.020661e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3138</td>\n",
       "      <td>0.3138</td>\n",
       "      <td>0</td>\n",
       "      <td>5.020661e+08</td>\n",
       "      <td>5.020661e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>20181231</td>\n",
       "      <td>元</td>\n",
       "      <td>5.228308e+09</td>\n",
       "      <td>5.228308e+09</td>\n",
       "      <td>3.527055e+09</td>\n",
       "      <td>2.364930e+09</td>\n",
       "      <td>2.838358e+07</td>\n",
       "      <td>7.653167e+08</td>\n",
       "      <td>1.335025e+08</td>\n",
       "      <td>1.816713e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.451367e+09</td>\n",
       "      <td>1.451367e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.9071</td>\n",
       "      <td>0.9071</td>\n",
       "      <td>0</td>\n",
       "      <td>1.451367e+09</td>\n",
       "      <td>1.451367e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>20180930</td>\n",
       "      <td>元</td>\n",
       "      <td>3.494879e+09</td>\n",
       "      <td>3.494879e+09</td>\n",
       "      <td>2.210957e+09</td>\n",
       "      <td>1.507394e+09</td>\n",
       "      <td>1.769687e+07</td>\n",
       "      <td>4.721613e+08</td>\n",
       "      <td>1.839704e+08</td>\n",
       "      <td>6.834894e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.086588e+09</td>\n",
       "      <td>1.086588e+09</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.6791</td>\n",
       "      <td>0.6791</td>\n",
       "      <td>0</td>\n",
       "      <td>1.086588e+09</td>\n",
       "      <td>1.086588e+09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>20180630</td>\n",
       "      <td>元</td>\n",
       "      <td>2.071876e+09</td>\n",
       "      <td>2.071876e+09</td>\n",
       "      <td>1.270661e+09</td>\n",
       "      <td>8.453442e+08</td>\n",
       "      <td>1.191289e+07</td>\n",
       "      <td>2.941416e+08</td>\n",
       "      <td>1.045435e+08</td>\n",
       "      <td>1.777847e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>6.823785e+08</td>\n",
       "      <td>6.823785e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.4265</td>\n",
       "      <td>0.4265</td>\n",
       "      <td>0</td>\n",
       "      <td>6.823785e+08</td>\n",
       "      <td>6.823785e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20180331</td>\n",
       "      <td>元</td>\n",
       "      <td>8.383283e+08</td>\n",
       "      <td>8.383283e+08</td>\n",
       "      <td>5.301718e+08</td>\n",
       "      <td>3.775706e+08</td>\n",
       "      <td>3.446958e+06</td>\n",
       "      <td>8.700206e+07</td>\n",
       "      <td>5.381581e+07</td>\n",
       "      <td>3.132290e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>2.596324e+08</td>\n",
       "      <td>2.596324e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1623</td>\n",
       "      <td>0.1623</td>\n",
       "      <td>0</td>\n",
       "      <td>2.596324e+08</td>\n",
       "      <td>2.596324e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20171231</td>\n",
       "      <td>元</td>\n",
       "      <td>1.342569e+09</td>\n",
       "      <td>1.342569e+09</td>\n",
       "      <td>8.372390e+08</td>\n",
       "      <td>2.880615e+08</td>\n",
       "      <td>1.219603e+07</td>\n",
       "      <td>3.143401e+08</td>\n",
       "      <td>1.873274e+08</td>\n",
       "      <td>-1.209225e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>4.322754e+08</td>\n",
       "      <td>4.322754e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2700</td>\n",
       "      <td>0.2700</td>\n",
       "      <td>0</td>\n",
       "      <td>4.322754e+08</td>\n",
       "      <td>4.322754e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>20170930</td>\n",
       "      <td>元</td>\n",
       "      <td>7.690548e+08</td>\n",
       "      <td>7.690548e+08</td>\n",
       "      <td>4.441503e+08</td>\n",
       "      <td>9.245599e+07</td>\n",
       "      <td>6.689791e+06</td>\n",
       "      <td>1.885112e+08</td>\n",
       "      <td>1.267347e+08</td>\n",
       "      <td>-6.744314e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>2.852348e+08</td>\n",
       "      <td>2.852348e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1783</td>\n",
       "      <td>0.1783</td>\n",
       "      <td>0</td>\n",
       "      <td>2.852348e+08</td>\n",
       "      <td>2.852348e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>20170630</td>\n",
       "      <td>元</td>\n",
       "      <td>4.451620e+08</td>\n",
       "      <td>4.451620e+08</td>\n",
       "      <td>2.489089e+08</td>\n",
       "      <td>3.444997e+07</td>\n",
       "      <td>5.166075e+06</td>\n",
       "      <td>1.069302e+08</td>\n",
       "      <td>7.909058e+07</td>\n",
       "      <td>-6.392373e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.717901e+08</td>\n",
       "      <td>1.717901e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0</td>\n",
       "      <td>1.717901e+08</td>\n",
       "      <td>1.717901e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>20170331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.622370e+08</td>\n",
       "      <td>1.622370e+08</td>\n",
       "      <td>9.485878e+07</td>\n",
       "      <td>1.002407e+07</td>\n",
       "      <td>6.873437e+05</td>\n",
       "      <td>3.454272e+07</td>\n",
       "      <td>3.897243e+07</td>\n",
       "      <td>-2.811938e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>6.031745e+07</td>\n",
       "      <td>6.031745e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0400</td>\n",
       "      <td>0.0400</td>\n",
       "      <td>0</td>\n",
       "      <td>6.031745e+07</td>\n",
       "      <td>6.031745e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>20161231</td>\n",
       "      <td>元</td>\n",
       "      <td>4.459472e+08</td>\n",
       "      <td>4.459472e+08</td>\n",
       "      <td>4.163816e+08</td>\n",
       "      <td>3.521882e+07</td>\n",
       "      <td>5.538279e+06</td>\n",
       "      <td>2.016168e+08</td>\n",
       "      <td>1.543616e+08</td>\n",
       "      <td>-1.845406e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>3.252031e+07</td>\n",
       "      <td>3.252031e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0200</td>\n",
       "      <td>0.0200</td>\n",
       "      <td>0</td>\n",
       "      <td>3.252031e+07</td>\n",
       "      <td>3.252031e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>20160930</td>\n",
       "      <td>元</td>\n",
       "      <td>2.732335e+08</td>\n",
       "      <td>2.732335e+08</td>\n",
       "      <td>2.724444e+08</td>\n",
       "      <td>1.987151e+07</td>\n",
       "      <td>1.156749e+06</td>\n",
       "      <td>1.287736e+08</td>\n",
       "      <td>1.051396e+08</td>\n",
       "      <td>-1.401248e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>6.761262e+06</td>\n",
       "      <td>6.761262e+06</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0042</td>\n",
       "      <td>0.0042</td>\n",
       "      <td>0</td>\n",
       "      <td>6.761262e+06</td>\n",
       "      <td>6.761262e+06</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>20160630</td>\n",
       "      <td>元</td>\n",
       "      <td>1.839440e+08</td>\n",
       "      <td>1.839440e+08</td>\n",
       "      <td>1.748111e+08</td>\n",
       "      <td>1.653117e+07</td>\n",
       "      <td>6.061102e+05</td>\n",
       "      <td>7.744687e+07</td>\n",
       "      <td>6.725415e+07</td>\n",
       "      <td>-9.199014e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.203886e+07</td>\n",
       "      <td>1.203886e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>0</td>\n",
       "      <td>1.203886e+07</td>\n",
       "      <td>1.203886e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>20160331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.437181e+08</td>\n",
       "      <td>1.437181e+08</td>\n",
       "      <td>7.716280e+07</td>\n",
       "      <td>9.824917e+06</td>\n",
       "      <td>5.782926e+05</td>\n",
       "      <td>2.779000e+07</td>\n",
       "      <td>3.405929e+07</td>\n",
       "      <td>-4.364309e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>5.919843e+07</td>\n",
       "      <td>5.919843e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>0</td>\n",
       "      <td>5.919843e+07</td>\n",
       "      <td>5.919843e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>20151231</td>\n",
       "      <td>元</td>\n",
       "      <td>7.127381e+08</td>\n",
       "      <td>7.127381e+08</td>\n",
       "      <td>4.943913e+08</td>\n",
       "      <td>1.417646e+08</td>\n",
       "      <td>4.710302e+06</td>\n",
       "      <td>2.391420e+08</td>\n",
       "      <td>1.258705e+08</td>\n",
       "      <td>-2.759567e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.974019e+08</td>\n",
       "      <td>1.974019e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2500</td>\n",
       "      <td>0.2500</td>\n",
       "      <td>0</td>\n",
       "      <td>1.974019e+08</td>\n",
       "      <td>1.974019e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>20150930</td>\n",
       "      <td>元</td>\n",
       "      <td>5.552421e+08</td>\n",
       "      <td>5.552421e+08</td>\n",
       "      <td>3.745873e+08</td>\n",
       "      <td>1.295146e+08</td>\n",
       "      <td>3.145295e+06</td>\n",
       "      <td>1.598761e+08</td>\n",
       "      <td>8.937196e+07</td>\n",
       "      <td>-2.026475e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.604950e+08</td>\n",
       "      <td>1.604950e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2000</td>\n",
       "      <td>0.2000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.604950e+08</td>\n",
       "      <td>1.604950e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>20150630</td>\n",
       "      <td>元</td>\n",
       "      <td>3.846178e+08</td>\n",
       "      <td>3.846178e+08</td>\n",
       "      <td>2.605976e+08</td>\n",
       "      <td>1.122350e+08</td>\n",
       "      <td>2.376026e+06</td>\n",
       "      <td>9.427485e+07</td>\n",
       "      <td>5.650317e+07</td>\n",
       "      <td>-1.266529e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.081221e+08</td>\n",
       "      <td>1.081221e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1400</td>\n",
       "      <td>0.1400</td>\n",
       "      <td>0</td>\n",
       "      <td>1.081221e+08</td>\n",
       "      <td>1.081221e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>20150331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.964726e+08</td>\n",
       "      <td>1.964726e+08</td>\n",
       "      <td>1.430482e+08</td>\n",
       "      <td>7.867512e+07</td>\n",
       "      <td>1.049326e+06</td>\n",
       "      <td>3.730860e+07</td>\n",
       "      <td>2.787392e+07</td>\n",
       "      <td>-6.311175e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>4.770840e+07</td>\n",
       "      <td>4.770840e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0600</td>\n",
       "      <td>0.0600</td>\n",
       "      <td>0</td>\n",
       "      <td>4.770840e+07</td>\n",
       "      <td>4.770840e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>20141231</td>\n",
       "      <td>元</td>\n",
       "      <td>8.009375e+08</td>\n",
       "      <td>8.009375e+08</td>\n",
       "      <td>6.283652e+08</td>\n",
       "      <td>3.107933e+08</td>\n",
       "      <td>7.097341e+06</td>\n",
       "      <td>2.106387e+08</td>\n",
       "      <td>1.115840e+08</td>\n",
       "      <td>-2.458272e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.480040e+08</td>\n",
       "      <td>1.480040e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1900</td>\n",
       "      <td>0.1900</td>\n",
       "      <td>0</td>\n",
       "      <td>1.480040e+08</td>\n",
       "      <td>1.480040e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>20140930</td>\n",
       "      <td>元</td>\n",
       "      <td>5.772012e+08</td>\n",
       "      <td>5.772012e+08</td>\n",
       "      <td>4.181663e+08</td>\n",
       "      <td>2.223132e+08</td>\n",
       "      <td>4.984528e+06</td>\n",
       "      <td>1.206588e+08</td>\n",
       "      <td>7.484325e+07</td>\n",
       "      <td>-1.842650e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.369069e+08</td>\n",
       "      <td>1.369069e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1700</td>\n",
       "      <td>0.1700</td>\n",
       "      <td>0</td>\n",
       "      <td>1.369069e+08</td>\n",
       "      <td>1.369069e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>20140630</td>\n",
       "      <td>元</td>\n",
       "      <td>3.804983e+08</td>\n",
       "      <td>3.804983e+08</td>\n",
       "      <td>2.685228e+08</td>\n",
       "      <td>1.460294e+08</td>\n",
       "      <td>3.646606e+06</td>\n",
       "      <td>6.970584e+07</td>\n",
       "      <td>4.988302e+07</td>\n",
       "      <td>-1.338157e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>9.587459e+07</td>\n",
       "      <td>9.587459e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1200</td>\n",
       "      <td>0.1200</td>\n",
       "      <td>0</td>\n",
       "      <td>9.587459e+07</td>\n",
       "      <td>9.587459e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>20140331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.626753e+08</td>\n",
       "      <td>1.626753e+08</td>\n",
       "      <td>1.130584e+08</td>\n",
       "      <td>6.820405e+07</td>\n",
       "      <td>1.359633e+06</td>\n",
       "      <td>1.997322e+07</td>\n",
       "      <td>2.598349e+07</td>\n",
       "      <td>-6.084446e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>4.259445e+07</td>\n",
       "      <td>4.259445e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0</td>\n",
       "      <td>4.259445e+07</td>\n",
       "      <td>4.259445e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>20131231</td>\n",
       "      <td>元</td>\n",
       "      <td>7.801779e+08</td>\n",
       "      <td>7.801779e+08</td>\n",
       "      <td>6.337309e+08</td>\n",
       "      <td>3.080549e+08</td>\n",
       "      <td>8.305535e+06</td>\n",
       "      <td>1.489785e+08</td>\n",
       "      <td>1.523629e+08</td>\n",
       "      <td>-2.501208e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.303478e+08</td>\n",
       "      <td>1.303478e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3300</td>\n",
       "      <td>0.3300</td>\n",
       "      <td>0</td>\n",
       "      <td>1.303478e+08</td>\n",
       "      <td>1.303478e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>20130930</td>\n",
       "      <td>元</td>\n",
       "      <td>5.802861e+08</td>\n",
       "      <td>5.802861e+08</td>\n",
       "      <td>4.317369e+08</td>\n",
       "      <td>2.471864e+08</td>\n",
       "      <td>5.599594e+06</td>\n",
       "      <td>9.909023e+07</td>\n",
       "      <td>8.863074e+07</td>\n",
       "      <td>-1.855409e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.315284e+08</td>\n",
       "      <td>1.315284e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3300</td>\n",
       "      <td>0.3300</td>\n",
       "      <td>0</td>\n",
       "      <td>1.315284e+08</td>\n",
       "      <td>1.315284e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>20130630</td>\n",
       "      <td>元</td>\n",
       "      <td>4.255763e+08</td>\n",
       "      <td>4.255763e+08</td>\n",
       "      <td>3.088316e+08</td>\n",
       "      <td>1.883981e+08</td>\n",
       "      <td>4.172664e+06</td>\n",
       "      <td>5.953447e+07</td>\n",
       "      <td>6.397482e+07</td>\n",
       "      <td>-1.510489e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.022422e+08</td>\n",
       "      <td>1.022422e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2600</td>\n",
       "      <td>0.2600</td>\n",
       "      <td>0</td>\n",
       "      <td>1.022422e+08</td>\n",
       "      <td>1.022422e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>20130331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.845495e+08</td>\n",
       "      <td>1.845495e+08</td>\n",
       "      <td>1.380217e+08</td>\n",
       "      <td>9.368991e+07</td>\n",
       "      <td>1.639516e+06</td>\n",
       "      <td>2.354024e+07</td>\n",
       "      <td>2.209933e+07</td>\n",
       "      <td>-5.888346e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>4.130339e+07</td>\n",
       "      <td>4.130339e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1000</td>\n",
       "      <td>0.1000</td>\n",
       "      <td>0</td>\n",
       "      <td>4.130339e+07</td>\n",
       "      <td>4.130339e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>20121231</td>\n",
       "      <td>元</td>\n",
       "      <td>7.646197e+08</td>\n",
       "      <td>7.646197e+08</td>\n",
       "      <td>5.491002e+08</td>\n",
       "      <td>3.382518e+08</td>\n",
       "      <td>7.152259e+06</td>\n",
       "      <td>1.488400e+08</td>\n",
       "      <td>8.465827e+07</td>\n",
       "      <td>-3.124095e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>2.179439e+08</td>\n",
       "      <td>2.179439e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5400</td>\n",
       "      <td>0.5400</td>\n",
       "      <td>0</td>\n",
       "      <td>2.179439e+08</td>\n",
       "      <td>2.179439e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>20120930</td>\n",
       "      <td>元</td>\n",
       "      <td>4.969606e+08</td>\n",
       "      <td>4.969606e+08</td>\n",
       "      <td>3.682727e+08</td>\n",
       "      <td>2.245410e+08</td>\n",
       "      <td>4.730511e+06</td>\n",
       "      <td>1.020268e+08</td>\n",
       "      <td>5.560137e+07</td>\n",
       "      <td>-2.383421e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.437329e+08</td>\n",
       "      <td>1.437329e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3600</td>\n",
       "      <td>0.3600</td>\n",
       "      <td>0</td>\n",
       "      <td>1.437329e+08</td>\n",
       "      <td>1.437329e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>20120630</td>\n",
       "      <td>元</td>\n",
       "      <td>3.279894e+08</td>\n",
       "      <td>3.279894e+08</td>\n",
       "      <td>2.379716e+08</td>\n",
       "      <td>1.554276e+08</td>\n",
       "      <td>3.504702e+06</td>\n",
       "      <td>5.362713e+07</td>\n",
       "      <td>3.534834e+07</td>\n",
       "      <td>-1.344091e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.085375e+08</td>\n",
       "      <td>1.085375e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2700</td>\n",
       "      <td>0.2700</td>\n",
       "      <td>0</td>\n",
       "      <td>1.085375e+08</td>\n",
       "      <td>1.085375e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>20120331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.385710e+08</td>\n",
       "      <td>1.385710e+08</td>\n",
       "      <td>9.805952e+07</td>\n",
       "      <td>6.784050e+07</td>\n",
       "      <td>9.815469e+05</td>\n",
       "      <td>1.644966e+07</td>\n",
       "      <td>1.616386e+07</td>\n",
       "      <td>-6.234288e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>3.594291e+07</td>\n",
       "      <td>3.594291e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0900</td>\n",
       "      <td>0.0900</td>\n",
       "      <td>0</td>\n",
       "      <td>3.594291e+07</td>\n",
       "      <td>3.594291e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>20111231</td>\n",
       "      <td>元</td>\n",
       "      <td>6.287400e+08</td>\n",
       "      <td>6.287400e+08</td>\n",
       "      <td>4.408832e+08</td>\n",
       "      <td>2.505863e+08</td>\n",
       "      <td>8.854633e+06</td>\n",
       "      <td>1.295373e+08</td>\n",
       "      <td>7.734728e+07</td>\n",
       "      <td>-3.310231e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.963836e+08</td>\n",
       "      <td>1.963836e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.4900</td>\n",
       "      <td>0.4900</td>\n",
       "      <td>0</td>\n",
       "      <td>1.963836e+08</td>\n",
       "      <td>1.963836e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>20110930</td>\n",
       "      <td>元</td>\n",
       "      <td>4.566521e+08</td>\n",
       "      <td>4.566521e+08</td>\n",
       "      <td>3.098315e+08</td>\n",
       "      <td>1.787144e+08</td>\n",
       "      <td>6.676691e+06</td>\n",
       "      <td>8.658443e+07</td>\n",
       "      <td>5.510714e+07</td>\n",
       "      <td>-2.516889e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.289811e+08</td>\n",
       "      <td>1.289811e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3200</td>\n",
       "      <td>0.3200</td>\n",
       "      <td>0</td>\n",
       "      <td>1.289811e+08</td>\n",
       "      <td>1.289811e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>20110630</td>\n",
       "      <td>元</td>\n",
       "      <td>3.124870e+08</td>\n",
       "      <td>3.124870e+08</td>\n",
       "      <td>2.012906e+08</td>\n",
       "      <td>1.131729e+08</td>\n",
       "      <td>5.127279e+06</td>\n",
       "      <td>5.440435e+07</td>\n",
       "      <td>3.559293e+07</td>\n",
       "      <td>-1.550309e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>9.758907e+07</td>\n",
       "      <td>9.758907e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2400</td>\n",
       "      <td>0.2400</td>\n",
       "      <td>0</td>\n",
       "      <td>9.758907e+07</td>\n",
       "      <td>9.758907e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>20110331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.287561e+08</td>\n",
       "      <td>1.287561e+08</td>\n",
       "      <td>9.348366e+07</td>\n",
       "      <td>4.817797e+07</td>\n",
       "      <td>1.883350e+06</td>\n",
       "      <td>3.081902e+07</td>\n",
       "      <td>1.815244e+07</td>\n",
       "      <td>-6.850567e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>3.021611e+07</td>\n",
       "      <td>3.021611e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0800</td>\n",
       "      <td>0.0800</td>\n",
       "      <td>0</td>\n",
       "      <td>3.021611e+07</td>\n",
       "      <td>3.021611e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>20101231</td>\n",
       "      <td>元</td>\n",
       "      <td>7.373136e+08</td>\n",
       "      <td>7.373136e+08</td>\n",
       "      <td>4.434078e+08</td>\n",
       "      <td>2.693060e+08</td>\n",
       "      <td>1.078073e+07</td>\n",
       "      <td>1.152408e+08</td>\n",
       "      <td>5.021841e+07</td>\n",
       "      <td>-5.342880e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>2.567881e+08</td>\n",
       "      <td>2.567881e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.6900</td>\n",
       "      <td>0.6900</td>\n",
       "      <td>0</td>\n",
       "      <td>2.567881e+08</td>\n",
       "      <td>2.567881e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>20100930</td>\n",
       "      <td>元</td>\n",
       "      <td>4.723223e+08</td>\n",
       "      <td>4.723223e+08</td>\n",
       "      <td>2.756524e+08</td>\n",
       "      <td>1.629623e+08</td>\n",
       "      <td>7.566485e+06</td>\n",
       "      <td>7.280255e+07</td>\n",
       "      <td>3.214855e+07</td>\n",
       "      <td>-1.437665e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.731210e+08</td>\n",
       "      <td>1.731210e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.4800</td>\n",
       "      <td>0.4800</td>\n",
       "      <td>0</td>\n",
       "      <td>1.731210e+08</td>\n",
       "      <td>1.731210e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>20100630</td>\n",
       "      <td>元</td>\n",
       "      <td>3.308263e+08</td>\n",
       "      <td>3.308263e+08</td>\n",
       "      <td>1.781990e+08</td>\n",
       "      <td>1.024358e+08</td>\n",
       "      <td>5.507258e+06</td>\n",
       "      <td>4.802382e+07</td>\n",
       "      <td>2.181796e+07</td>\n",
       "      <td>-6.414912e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>1.311395e+08</td>\n",
       "      <td>1.311395e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3600</td>\n",
       "      <td>0.3600</td>\n",
       "      <td>0</td>\n",
       "      <td>1.311395e+08</td>\n",
       "      <td>1.311395e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>20100331</td>\n",
       "      <td>元</td>\n",
       "      <td>1.063393e+08</td>\n",
       "      <td>1.063393e+08</td>\n",
       "      <td>7.863087e+07</td>\n",
       "      <td>4.370640e+07</td>\n",
       "      <td>1.796246e+06</td>\n",
       "      <td>2.168920e+07</td>\n",
       "      <td>1.042695e+07</td>\n",
       "      <td>-9.572709e+04</td>\n",
       "      <td>...</td>\n",
       "      <td>2.369565e+07</td>\n",
       "      <td>2.369565e+07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>0.0700</td>\n",
       "      <td>0</td>\n",
       "      <td>2.369565e+07</td>\n",
       "      <td>2.369565e+07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>20091231</td>\n",
       "      <td>元</td>\n",
       "      <td>6.040475e+08</td>\n",
       "      <td>6.040475e+08</td>\n",
       "      <td>3.465344e+08</td>\n",
       "      <td>1.885044e+08</td>\n",
       "      <td>9.912864e+06</td>\n",
       "      <td>1.058044e+08</td>\n",
       "      <td>4.203399e+07</td>\n",
       "      <td>-3.599439e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>2.315897e+08</td>\n",
       "      <td>2.315897e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.6400</td>\n",
       "      <td>0.6400</td>\n",
       "      <td>0</td>\n",
       "      <td>2.315897e+08</td>\n",
       "      <td>2.315897e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>20090930</td>\n",
       "      <td>元</td>\n",
       "      <td>4.184630e+08</td>\n",
       "      <td>4.184630e+08</td>\n",
       "      <td>2.456036e+08</td>\n",
       "      <td>1.340287e+08</td>\n",
       "      <td>7.258599e+06</td>\n",
       "      <td>7.215039e+07</td>\n",
       "      <td>3.161526e+07</td>\n",
       "      <td>-1.088891e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>1.535120e+08</td>\n",
       "      <td>1.535120e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.4300</td>\n",
       "      <td>0.4300</td>\n",
       "      <td>0</td>\n",
       "      <td>1.535120e+08</td>\n",
       "      <td>1.535120e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>20081231</td>\n",
       "      <td>元</td>\n",
       "      <td>5.903357e+08</td>\n",
       "      <td>5.903357e+08</td>\n",
       "      <td>3.689559e+08</td>\n",
       "      <td>2.148530e+08</td>\n",
       "      <td>9.395463e+06</td>\n",
       "      <td>1.089430e+08</td>\n",
       "      <td>3.123171e+07</td>\n",
       "      <td>7.728633e+04</td>\n",
       "      <td>...</td>\n",
       "      <td>1.900513e+08</td>\n",
       "      <td>1.900513e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5300</td>\n",
       "      <td>0.5300</td>\n",
       "      <td>0</td>\n",
       "      <td>1.900513e+08</td>\n",
       "      <td>1.900513e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>20071231</td>\n",
       "      <td>元</td>\n",
       "      <td>4.924289e+08</td>\n",
       "      <td>4.924289e+08</td>\n",
       "      <td>3.124258e+08</td>\n",
       "      <td>2.073765e+08</td>\n",
       "      <td>7.231585e+06</td>\n",
       "      <td>8.375439e+07</td>\n",
       "      <td>1.406509e+07</td>\n",
       "      <td>-2.556585e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>1.520091e+08</td>\n",
       "      <td>1.520091e+08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.4200</td>\n",
       "      <td>0.4200</td>\n",
       "      <td>0</td>\n",
       "      <td>1.520091e+08</td>\n",
       "      <td>1.520091e+08</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>19700101</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>57 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        报表日期 单位       一、营业总收入          营业收入       二、营业总成本          营业成本  \\\n",
       "0   20221231  元  3.826401e+10  3.826401e+10  2.904984e+10  2.539550e+10   \n",
       "1   20220930  元  2.782329e+10  2.782329e+10  2.107379e+10  1.858638e+10   \n",
       "2   20220630  元  1.835375e+10  1.835375e+10  1.381560e+10  1.221367e+10   \n",
       "3   20220331  元  8.841150e+09  8.841150e+09  6.503327e+09  5.864038e+09   \n",
       "4   20211231  元  3.065242e+10  3.065242e+10  1.846648e+10  1.562180e+10   \n",
       "5   20210930  元  2.182866e+10  2.182866e+10  1.182180e+10  1.003811e+10   \n",
       "6   20210630  元  1.317148e+10  1.317148e+10  6.662966e+09  5.491862e+09   \n",
       "7   20210331  元  3.926601e+09  3.926601e+09  2.756079e+09  2.318670e+09   \n",
       "8   20201231  元  1.519037e+10  1.519037e+10  1.117980e+10  9.268009e+09   \n",
       "9   20200930  元  1.104979e+10  1.104979e+10  7.969426e+09  6.627694e+09   \n",
       "10  20200630  元  6.993723e+09  6.993723e+09  5.036619e+09  4.303097e+09   \n",
       "11  20200331  元  2.634599e+09  2.634599e+09  1.939468e+09  1.657523e+09   \n",
       "12  20191231  元  1.058732e+10  1.058732e+10  7.709980e+09  6.135815e+09   \n",
       "13  20190930  元  7.666171e+09  7.666171e+09  5.475325e+09  4.450911e+09   \n",
       "14  20190630  元  5.038678e+09  5.038678e+09  3.600468e+09  2.964282e+09   \n",
       "15  20190331  元  2.293537e+09  2.293537e+09  1.673250e+09  1.378965e+09   \n",
       "16  20181231  元  5.228308e+09  5.228308e+09  3.527055e+09  2.364930e+09   \n",
       "17  20180930  元  3.494879e+09  3.494879e+09  2.210957e+09  1.507394e+09   \n",
       "18  20180630  元  2.071876e+09  2.071876e+09  1.270661e+09  8.453442e+08   \n",
       "19  20180331  元  8.383283e+08  8.383283e+08  5.301718e+08  3.775706e+08   \n",
       "20  20171231  元  1.342569e+09  1.342569e+09  8.372390e+08  2.880615e+08   \n",
       "21  20170930  元  7.690548e+08  7.690548e+08  4.441503e+08  9.245599e+07   \n",
       "22  20170630  元  4.451620e+08  4.451620e+08  2.489089e+08  3.444997e+07   \n",
       "23  20170331  元  1.622370e+08  1.622370e+08  9.485878e+07  1.002407e+07   \n",
       "24  20161231  元  4.459472e+08  4.459472e+08  4.163816e+08  3.521882e+07   \n",
       "25  20160930  元  2.732335e+08  2.732335e+08  2.724444e+08  1.987151e+07   \n",
       "26  20160630  元  1.839440e+08  1.839440e+08  1.748111e+08  1.653117e+07   \n",
       "27  20160331  元  1.437181e+08  1.437181e+08  7.716280e+07  9.824917e+06   \n",
       "28  20151231  元  7.127381e+08  7.127381e+08  4.943913e+08  1.417646e+08   \n",
       "29  20150930  元  5.552421e+08  5.552421e+08  3.745873e+08  1.295146e+08   \n",
       "30  20150630  元  3.846178e+08  3.846178e+08  2.605976e+08  1.122350e+08   \n",
       "31  20150331  元  1.964726e+08  1.964726e+08  1.430482e+08  7.867512e+07   \n",
       "32  20141231  元  8.009375e+08  8.009375e+08  6.283652e+08  3.107933e+08   \n",
       "33  20140930  元  5.772012e+08  5.772012e+08  4.181663e+08  2.223132e+08   \n",
       "34  20140630  元  3.804983e+08  3.804983e+08  2.685228e+08  1.460294e+08   \n",
       "35  20140331  元  1.626753e+08  1.626753e+08  1.130584e+08  6.820405e+07   \n",
       "36  20131231  元  7.801779e+08  7.801779e+08  6.337309e+08  3.080549e+08   \n",
       "37  20130930  元  5.802861e+08  5.802861e+08  4.317369e+08  2.471864e+08   \n",
       "38  20130630  元  4.255763e+08  4.255763e+08  3.088316e+08  1.883981e+08   \n",
       "39  20130331  元  1.845495e+08  1.845495e+08  1.380217e+08  9.368991e+07   \n",
       "40  20121231  元  7.646197e+08  7.646197e+08  5.491002e+08  3.382518e+08   \n",
       "41  20120930  元  4.969606e+08  4.969606e+08  3.682727e+08  2.245410e+08   \n",
       "42  20120630  元  3.279894e+08  3.279894e+08  2.379716e+08  1.554276e+08   \n",
       "43  20120331  元  1.385710e+08  1.385710e+08  9.805952e+07  6.784050e+07   \n",
       "44  20111231  元  6.287400e+08  6.287400e+08  4.408832e+08  2.505863e+08   \n",
       "45  20110930  元  4.566521e+08  4.566521e+08  3.098315e+08  1.787144e+08   \n",
       "46  20110630  元  3.124870e+08  3.124870e+08  2.012906e+08  1.131729e+08   \n",
       "47  20110331  元  1.287561e+08  1.287561e+08  9.348366e+07  4.817797e+07   \n",
       "48  20101231  元  7.373136e+08  7.373136e+08  4.434078e+08  2.693060e+08   \n",
       "49  20100930  元  4.723223e+08  4.723223e+08  2.756524e+08  1.629623e+08   \n",
       "50  20100630  元  3.308263e+08  3.308263e+08  1.781990e+08  1.024358e+08   \n",
       "51  20100331  元  1.063393e+08  1.063393e+08  7.863087e+07  4.370640e+07   \n",
       "52  20091231  元  6.040475e+08  6.040475e+08  3.465344e+08  1.885044e+08   \n",
       "53  20090930  元  4.184630e+08  4.184630e+08  2.456036e+08  1.340287e+08   \n",
       "54  20081231  元  5.903357e+08  5.903357e+08  3.689559e+08  2.148530e+08   \n",
       "55  20071231  元  4.924289e+08  4.924289e+08  3.124258e+08  2.073765e+08   \n",
       "56  19700101  0  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00   \n",
       "\n",
       "         营业税金及附加          销售费用          管理费用          财务费用  ...         五、净利润  \\\n",
       "0   1.770219e+08  2.235237e+09  3.741262e+08  1.379832e+07  ...  7.539000e+09   \n",
       "1   1.273912e+08  1.469335e+09  2.758392e+08  7.344287e+06  ...  5.607155e+09   \n",
       "2   8.491797e+07  9.506678e+08  1.716994e+08  6.921587e+06  ...  3.729017e+09   \n",
       "3   3.662546e+07  3.626753e+08  7.206652e+07  7.030685e+06  ...  1.922757e+09   \n",
       "4   1.352342e+08  1.834807e+09  3.001955e+08  2.182127e+07  ...  1.020855e+10   \n",
       "5   9.743332e+07  1.225365e+09  2.008999e+08  1.965119e+07  ...  8.403608e+09   \n",
       "6   6.201584e+07  7.781028e+08  1.290693e+08  3.918659e+07  ...  5.490650e+09   \n",
       "7   1.638660e+07  2.719420e+08  5.710977e+07  3.035498e+07  ...  9.381791e+08   \n",
       "8   7.098972e+07  1.197507e+09  2.122592e+08  1.313844e+08  ...  3.301327e+09   \n",
       "9   4.983327e+07  8.189057e+08  1.415956e+08  1.104116e+08  ...  2.478596e+09   \n",
       "10  3.269298e+07  4.294139e+08  9.254171e+07  7.282094e+07  ...  1.504548e+09   \n",
       "11  1.127358e+07  1.366930e+08  4.782170e+07  3.870799e+07  ...  5.163634e+08   \n",
       "12  5.141446e+07  1.095580e+09  1.826917e+08  7.492645e+07  ...  2.366439e+09   \n",
       "13  3.538434e+07  7.086295e+08  1.262015e+08  4.967168e+07  ...  1.762941e+09   \n",
       "14  2.447402e+07  4.394425e+08  7.973578e+07  2.514876e+07  ...  1.146970e+09   \n",
       "15  9.417647e+06  1.640910e+08  4.015490e+07  1.023333e+07  ...  5.020661e+08   \n",
       "16  2.838358e+07  7.653167e+08  1.335025e+08  1.816713e+07  ...  1.451367e+09   \n",
       "17  1.769687e+07  4.721613e+08  1.839704e+08  6.834894e+06  ...  1.086588e+09   \n",
       "18  1.191289e+07  2.941416e+08  1.045435e+08  1.777847e+06  ...  6.823785e+08   \n",
       "19  3.446958e+06  8.700206e+07  5.381581e+07  3.132290e+05  ...  2.596324e+08   \n",
       "20  1.219603e+07  3.143401e+08  1.873274e+08 -1.209225e+07  ...  4.322754e+08   \n",
       "21  6.689791e+06  1.885112e+08  1.267347e+08 -6.744314e+06  ...  2.852348e+08   \n",
       "22  5.166075e+06  1.069302e+08  7.909058e+07 -6.392373e+06  ...  1.717901e+08   \n",
       "23  6.873437e+05  3.454272e+07  3.897243e+07 -2.811938e+06  ...  6.031745e+07   \n",
       "24  5.538279e+06  2.016168e+08  1.543616e+08 -1.845406e+07  ...  3.252031e+07   \n",
       "25  1.156749e+06  1.287736e+08  1.051396e+08 -1.401248e+07  ...  6.761262e+06   \n",
       "26  6.061102e+05  7.744687e+07  6.725415e+07 -9.199014e+06  ...  1.203886e+07   \n",
       "27  5.782926e+05  2.779000e+07  3.405929e+07 -4.364309e+06  ...  5.919843e+07   \n",
       "28  4.710302e+06  2.391420e+08  1.258705e+08 -2.759567e+07  ...  1.974019e+08   \n",
       "29  3.145295e+06  1.598761e+08  8.937196e+07 -2.026475e+07  ...  1.604950e+08   \n",
       "30  2.376026e+06  9.427485e+07  5.650317e+07 -1.266529e+07  ...  1.081221e+08   \n",
       "31  1.049326e+06  3.730860e+07  2.787392e+07 -6.311175e+06  ...  4.770840e+07   \n",
       "32  7.097341e+06  2.106387e+08  1.115840e+08 -2.458272e+07  ...  1.480040e+08   \n",
       "33  4.984528e+06  1.206588e+08  7.484325e+07 -1.842650e+07  ...  1.369069e+08   \n",
       "34  3.646606e+06  6.970584e+07  4.988302e+07 -1.338157e+07  ...  9.587459e+07   \n",
       "35  1.359633e+06  1.997322e+07  2.598349e+07 -6.084446e+06  ...  4.259445e+07   \n",
       "36  8.305535e+06  1.489785e+08  1.523629e+08 -2.501208e+07  ...  1.303478e+08   \n",
       "37  5.599594e+06  9.909023e+07  8.863074e+07 -1.855409e+07  ...  1.315284e+08   \n",
       "38  4.172664e+06  5.953447e+07  6.397482e+07 -1.510489e+07  ...  1.022422e+08   \n",
       "39  1.639516e+06  2.354024e+07  2.209933e+07 -5.888346e+06  ...  4.130339e+07   \n",
       "40  7.152259e+06  1.488400e+08  8.465827e+07 -3.124095e+07  ...  2.179439e+08   \n",
       "41  4.730511e+06  1.020268e+08  5.560137e+07 -2.383421e+07  ...  1.437329e+08   \n",
       "42  3.504702e+06  5.362713e+07  3.534834e+07 -1.344091e+07  ...  1.085375e+08   \n",
       "43  9.815469e+05  1.644966e+07  1.616386e+07 -6.234288e+06  ...  3.594291e+07   \n",
       "44  8.854633e+06  1.295373e+08  7.734728e+07 -3.310231e+07  ...  1.963836e+08   \n",
       "45  6.676691e+06  8.658443e+07  5.510714e+07 -2.516889e+07  ...  1.289811e+08   \n",
       "46  5.127279e+06  5.440435e+07  3.559293e+07 -1.550309e+07  ...  9.758907e+07   \n",
       "47  1.883350e+06  3.081902e+07  1.815244e+07 -6.850567e+06  ...  3.021611e+07   \n",
       "48  1.078073e+07  1.152408e+08  5.021841e+07 -5.342880e+06  ...  2.567881e+08   \n",
       "49  7.566485e+06  7.280255e+07  3.214855e+07 -1.437665e+06  ...  1.731210e+08   \n",
       "50  5.507258e+06  4.802382e+07  2.181796e+07 -6.414912e+05  ...  1.311395e+08   \n",
       "51  1.796246e+06  2.168920e+07  1.042695e+07 -9.572709e+04  ...  2.369565e+07   \n",
       "52  9.912864e+06  1.058044e+08  4.203399e+07 -3.599439e+05  ...  2.315897e+08   \n",
       "53  7.258599e+06  7.215039e+07  3.161526e+07 -1.088891e+05  ...  1.535120e+08   \n",
       "54  9.395463e+06  1.089430e+08  3.123171e+07  7.728633e+04  ...  1.900513e+08   \n",
       "55  7.231585e+06  8.375439e+07  1.406509e+07 -2.556585e+05  ...  1.520091e+08   \n",
       "56  0.000000e+00  0.000000e+00  0.000000e+00  0.000000e+00  ...  0.000000e+00   \n",
       "\n",
       "    归属于母公司所有者的净利润  少数股东损益  六、每股收益  基本每股收益(元/股)  稀释每股收益(元/股)  七、其他综合收益  \\\n",
       "0    7.539000e+09       0     0.0       4.7119       4.7119         0   \n",
       "1    5.607155e+09       0     0.0       3.5045       3.5045         0   \n",
       "2    3.729017e+09       0     0.0       2.3306       2.3306         0   \n",
       "3    1.922757e+09       0     0.0       1.2017       1.2017         0   \n",
       "4    1.020855e+10       0     0.0       6.3803       6.3803         0   \n",
       "5    8.403608e+09       0     0.0       5.2523       5.2523         0   \n",
       "6    5.490650e+09       0     0.0       3.4317       3.4317         0   \n",
       "7    9.381791e+08       0     0.0       0.5864       0.5864         0   \n",
       "8    3.301327e+09       0     0.0       2.0633       2.0633         0   \n",
       "9    2.478596e+09       0     0.0       1.5491       1.5491         0   \n",
       "10   1.504548e+09       0     0.0       0.9403       0.9403         0   \n",
       "11   5.163634e+08       0     0.0       0.3227       0.3227         0   \n",
       "12   2.366439e+09       0     0.0       1.4790       1.4790         0   \n",
       "13   1.762941e+09       0     0.0       1.1018       1.1018         0   \n",
       "14   1.146970e+09       0     0.0       0.7169       0.7169         0   \n",
       "15   5.020661e+08       0     0.0       0.3138       0.3138         0   \n",
       "16   1.451367e+09       0     0.0       0.9071       0.9071         0   \n",
       "17   1.086588e+09       0     0.0       0.6791       0.6791         0   \n",
       "18   6.823785e+08       0     0.0       0.4265       0.4265         0   \n",
       "19   2.596324e+08       0     0.0       0.1623       0.1623         0   \n",
       "20   4.322754e+08       0     0.0       0.2700       0.2700         0   \n",
       "21   2.852348e+08       0     0.0       0.1783       0.1783         0   \n",
       "22   1.717901e+08       0     0.0       0.1100       0.1100         0   \n",
       "23   6.031745e+07       0     0.0       0.0400       0.0400         0   \n",
       "24   3.252031e+07       0     0.0       0.0200       0.0200         0   \n",
       "25   6.761262e+06       0     0.0       0.0042       0.0042         0   \n",
       "26   1.203886e+07       0     0.0       0.0100       0.0100         0   \n",
       "27   5.919843e+07       0     0.0       0.0700       0.0700         0   \n",
       "28   1.974019e+08       0     0.0       0.2500       0.2500         0   \n",
       "29   1.604950e+08       0     0.0       0.2000       0.2000         0   \n",
       "30   1.081221e+08       0     0.0       0.1400       0.1400         0   \n",
       "31   4.770840e+07       0     0.0       0.0600       0.0600         0   \n",
       "32   1.480040e+08       0     0.0       0.1900       0.1900         0   \n",
       "33   1.369069e+08       0     0.0       0.1700       0.1700         0   \n",
       "34   9.587459e+07       0     0.0       0.1200       0.1200         0   \n",
       "35   4.259445e+07       0     0.0       0.1100       0.1100         0   \n",
       "36   1.303478e+08       0     0.0       0.3300       0.3300         0   \n",
       "37   1.315284e+08       0     0.0       0.3300       0.3300         0   \n",
       "38   1.022422e+08       0     0.0       0.2600       0.2600         0   \n",
       "39   4.130339e+07       0     0.0       0.1000       0.1000         0   \n",
       "40   2.179439e+08       0     0.0       0.5400       0.5400         0   \n",
       "41   1.437329e+08       0     0.0       0.3600       0.3600         0   \n",
       "42   1.085375e+08       0     0.0       0.2700       0.2700         0   \n",
       "43   3.594291e+07       0     0.0       0.0900       0.0900         0   \n",
       "44   1.963836e+08       0     0.0       0.4900       0.4900         0   \n",
       "45   1.289811e+08       0     0.0       0.3200       0.3200         0   \n",
       "46   9.758907e+07       0     0.0       0.2400       0.2400         0   \n",
       "47   3.021611e+07       0     0.0       0.0800       0.0800         0   \n",
       "48   2.567881e+08       0     0.0       0.6900       0.6900         0   \n",
       "49   1.731210e+08       0     0.0       0.4800       0.4800         0   \n",
       "50   1.311395e+08       0     0.0       0.3600       0.3600         0   \n",
       "51   2.369565e+07       0     0.0       0.0700       0.0700         0   \n",
       "52   2.315897e+08       0     0.0       0.6400       0.6400         0   \n",
       "53   1.535120e+08       0     0.0       0.4300       0.4300         0   \n",
       "54   1.900513e+08       0     0.0       0.5300       0.5300         0   \n",
       "55   1.520091e+08       0     0.0       0.4200       0.4200         0   \n",
       "56   0.000000e+00       0     0.0       0.0000       0.0000         0   \n",
       "\n",
       "        八、综合收益总额  归属于母公司所有者的综合收益总额  归属于少数股东的综合收益总额  \n",
       "0   7.539000e+09      7.539000e+09               0  \n",
       "1   5.607155e+09      5.607155e+09               0  \n",
       "2   3.729017e+09      3.729017e+09               0  \n",
       "3   1.922757e+09      1.922757e+09               0  \n",
       "4   1.020855e+10      1.020855e+10               0  \n",
       "5   8.403608e+09      8.403608e+09               0  \n",
       "6   5.490650e+09      5.490650e+09               0  \n",
       "7   9.381791e+08      9.381791e+08               0  \n",
       "8   3.301327e+09      3.301327e+09               0  \n",
       "9   2.478596e+09      2.478596e+09               0  \n",
       "10  1.504548e+09      1.504548e+09               0  \n",
       "11  5.163634e+08      5.163634e+08               0  \n",
       "12  2.366439e+09      2.366439e+09               0  \n",
       "13  1.762941e+09      1.762941e+09               0  \n",
       "14  1.146970e+09      1.146970e+09               0  \n",
       "15  5.020661e+08      5.020661e+08               0  \n",
       "16  1.451367e+09      1.451367e+09               0  \n",
       "17  1.086588e+09      1.086588e+09               0  \n",
       "18  6.823785e+08      6.823785e+08               0  \n",
       "19  2.596324e+08      2.596324e+08               0  \n",
       "20  4.322754e+08      4.322754e+08               0  \n",
       "21  2.852348e+08      2.852348e+08               0  \n",
       "22  1.717901e+08      1.717901e+08               0  \n",
       "23  6.031745e+07      6.031745e+07               0  \n",
       "24  3.252031e+07      3.252031e+07               0  \n",
       "25  6.761262e+06      6.761262e+06               0  \n",
       "26  1.203886e+07      1.203886e+07               0  \n",
       "27  5.919843e+07      5.919843e+07               0  \n",
       "28  1.974019e+08      1.974019e+08               0  \n",
       "29  1.604950e+08      1.604950e+08               0  \n",
       "30  1.081221e+08      1.081221e+08               0  \n",
       "31  4.770840e+07      4.770840e+07               0  \n",
       "32  1.480040e+08      1.480040e+08               0  \n",
       "33  1.369069e+08      1.369069e+08               0  \n",
       "34  9.587459e+07      9.587459e+07               0  \n",
       "35  4.259445e+07      4.259445e+07               0  \n",
       "36  1.303478e+08      1.303478e+08               0  \n",
       "37  1.315284e+08      1.315284e+08               0  \n",
       "38  1.022422e+08      1.022422e+08               0  \n",
       "39  4.130339e+07      4.130339e+07               0  \n",
       "40  2.179439e+08      2.179439e+08               0  \n",
       "41  1.437329e+08      1.437329e+08               0  \n",
       "42  1.085375e+08      1.085375e+08               0  \n",
       "43  3.594291e+07      3.594291e+07               0  \n",
       "44  1.963836e+08      1.963836e+08               0  \n",
       "45  1.289811e+08      1.289811e+08               0  \n",
       "46  9.758907e+07      9.758907e+07               0  \n",
       "47  3.021611e+07      3.021611e+07               0  \n",
       "48  2.567881e+08      2.567881e+08               0  \n",
       "49  1.731210e+08      1.731210e+08               0  \n",
       "50  1.311395e+08      1.311395e+08               0  \n",
       "51  2.369565e+07      2.369565e+07               0  \n",
       "52  2.315897e+08      2.315897e+08               0  \n",
       "53  1.535120e+08      1.535120e+08               0  \n",
       "54  1.900513e+08      1.900513e+08               0  \n",
       "55  1.520091e+08      1.520091e+08               0  \n",
       "56  0.000000e+00      0.000000e+00               0  \n",
       "\n",
       "[57 rows x 32 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_null_0=data.fillna(0,inplace=False)\n",
    "data_null_0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "39b18145",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "323a5ac1",
   "metadata": {},
   "outputs": [],
   "source": [
    "x=data['营业成本']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "c6ad71c3",
   "metadata": {},
   "outputs": [],
   "source": [
    "def MaxMinNormalization(x):\n",
    "    x=(x-np.min(x))/(np.max(x)-np.min(x))\n",
    "    return x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "3660796f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     1.000000\n",
       "1     0.731877\n",
       "2     0.480938\n",
       "3     0.230909\n",
       "4     0.615141\n",
       "5     0.395271\n",
       "6     0.216253\n",
       "7     0.091302\n",
       "8     0.364947\n",
       "9     0.260979\n",
       "10    0.169443\n",
       "11    0.065268\n",
       "12    0.241610\n",
       "13    0.175264\n",
       "14    0.116725\n",
       "15    0.054300\n",
       "16    0.093124\n",
       "17    0.059357\n",
       "18    0.033287\n",
       "19    0.014868\n",
       "20    0.011343\n",
       "21    0.003641\n",
       "22    0.001357\n",
       "23    0.000395\n",
       "24    0.001387\n",
       "25    0.000782\n",
       "26    0.000651\n",
       "27    0.000387\n",
       "28    0.005582\n",
       "29    0.005100\n",
       "30    0.004419\n",
       "31    0.003098\n",
       "32    0.012238\n",
       "33    0.008754\n",
       "34    0.005750\n",
       "35    0.002686\n",
       "36    0.012130\n",
       "37    0.009733\n",
       "38    0.007419\n",
       "39    0.003689\n",
       "40    0.013319\n",
       "41    0.008842\n",
       "42    0.006120\n",
       "43    0.002671\n",
       "44    0.009867\n",
       "45    0.007037\n",
       "46    0.004456\n",
       "47    0.001897\n",
       "48    0.010604\n",
       "49    0.006417\n",
       "50    0.004034\n",
       "51    0.001721\n",
       "52    0.007423\n",
       "53    0.005278\n",
       "54    0.008460\n",
       "55    0.008166\n",
       "56    0.000000\n",
       "Name: 营业成本, dtype: float64"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "MaxMinNormalization(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "c65f56c6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     2.539550e+10\n",
       "1     1.858638e+10\n",
       "2     1.221367e+10\n",
       "3     5.864038e+09\n",
       "4     1.562180e+10\n",
       "5     1.003811e+10\n",
       "6     5.491862e+09\n",
       "7     2.318670e+09\n",
       "8     9.268009e+09\n",
       "9     6.627694e+09\n",
       "10    4.303097e+09\n",
       "11    1.657523e+09\n",
       "12    6.135815e+09\n",
       "13    4.450911e+09\n",
       "14    2.964282e+09\n",
       "15    1.378965e+09\n",
       "16    2.364930e+09\n",
       "17    1.507394e+09\n",
       "18    8.453442e+08\n",
       "19    3.775706e+08\n",
       "20    2.880615e+08\n",
       "21    9.245599e+07\n",
       "22    3.444997e+07\n",
       "23    1.002407e+07\n",
       "24    3.521882e+07\n",
       "25    1.987151e+07\n",
       "26    1.653117e+07\n",
       "27    9.824917e+06\n",
       "28    1.417646e+08\n",
       "29    1.295146e+08\n",
       "30    1.122350e+08\n",
       "31    7.867512e+07\n",
       "32    3.107933e+08\n",
       "33    2.223132e+08\n",
       "34    1.460294e+08\n",
       "35    6.820405e+07\n",
       "36    3.080549e+08\n",
       "37    2.471864e+08\n",
       "38    1.883981e+08\n",
       "39    9.368991e+07\n",
       "40    3.382518e+08\n",
       "41    2.245410e+08\n",
       "42    1.554276e+08\n",
       "43    6.784050e+07\n",
       "44    2.505863e+08\n",
       "45    1.787144e+08\n",
       "46    1.131729e+08\n",
       "47    4.817797e+07\n",
       "48    2.693060e+08\n",
       "49    1.629623e+08\n",
       "50    1.024358e+08\n",
       "51    4.370640e+07\n",
       "52    1.885044e+08\n",
       "53    1.340287e+08\n",
       "54    2.148530e+08\n",
       "55    2.073765e+08\n",
       "56    0.000000e+00\n",
       "Name: 营业成本, dtype: float64"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "MaxMinNormalization(x).reset_index()\n",
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "e3ee573f",
   "metadata": {},
   "outputs": [],
   "source": [
    "bins=[0,9.368991e+07]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "77a3206a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0                   NaN\n",
       "1                   NaN\n",
       "2                   NaN\n",
       "3                   NaN\n",
       "4                   NaN\n",
       "5                   NaN\n",
       "6                   NaN\n",
       "7                   NaN\n",
       "8                   NaN\n",
       "9                   NaN\n",
       "10                  NaN\n",
       "11                  NaN\n",
       "12                  NaN\n",
       "13                  NaN\n",
       "14                  NaN\n",
       "15                  NaN\n",
       "16                  NaN\n",
       "17                  NaN\n",
       "18                  NaN\n",
       "19                  NaN\n",
       "20                  NaN\n",
       "21    (0.0, 93689910.0]\n",
       "22    (0.0, 93689910.0]\n",
       "23    (0.0, 93689910.0]\n",
       "24    (0.0, 93689910.0]\n",
       "25    (0.0, 93689910.0]\n",
       "26    (0.0, 93689910.0]\n",
       "27    (0.0, 93689910.0]\n",
       "28                  NaN\n",
       "29                  NaN\n",
       "30                  NaN\n",
       "31    (0.0, 93689910.0]\n",
       "32                  NaN\n",
       "33                  NaN\n",
       "34                  NaN\n",
       "35    (0.0, 93689910.0]\n",
       "36                  NaN\n",
       "37                  NaN\n",
       "38                  NaN\n",
       "39                  NaN\n",
       "40                  NaN\n",
       "41                  NaN\n",
       "42                  NaN\n",
       "43    (0.0, 93689910.0]\n",
       "44                  NaN\n",
       "45                  NaN\n",
       "46                  NaN\n",
       "47    (0.0, 93689910.0]\n",
       "48                  NaN\n",
       "49                  NaN\n",
       "50                  NaN\n",
       "51    (0.0, 93689910.0]\n",
       "52                  NaN\n",
       "53                  NaN\n",
       "54                  NaN\n",
       "55                  NaN\n",
       "56                  NaN\n",
       "Name: 营业成本, dtype: category\n",
       "Categories (1, interval[float64, right]): [(0.0, 93689910.0]]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.cut(x,bins,right=True ,labels=None ,retbins=False,precision=3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "89e3a8a9",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
